[offtopic] free database for NGO in Bangladesh

Kim Neunert <[email protected]>
Newsgroups gmane.linux.debian.devel.nonprofit
Message-ID <[email protected]> 
Hi,

My name is Kim Neunert from Germany. In the moment, I do a volunteer job 
at a hospital in bangladesh (http://www.crp-bangladesh.org). They have 
a Oracle 7 Database which is their Accounting system. They don't have 
an installation disk. The client is a proprietary Program which is no 
longer supported. I want to reprogram the database as a LAMP System and 
I'm searching for help in this topic. I know, that I'm offtopic but 
maybe, someone can help me to find some people who could perhaps 
support me in the next 2 and a half month that I'm here.
I had already extracted the the structure of the database. I'm new at 
PHP (and SQL) but I have experiences in C and Java (e.g. 
http://www.learn2prog.de).
Perhaps, somebody knows a good Mailinglist etc. where I could get 
"abstract support" about design decisions or somebody reviewing my code 
etc.?

It would be great if anybody could give me tips on that topic :-)

Kim Neunert (male)

P.S.: Please CC to my Mailadress because I'm not on the list (the 
connection in Bangladesh is pretty bad here and I don't want to cause 
additional costs to my NGO).
 
--------------------here the Table-Structure--------------------------
use accrp;
#SQL> describe AC_CODE1
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID1                                   CHAR(2)
# AC1_DESC                                 VARCHAR2(55)

create table AC_CODE1 (AC_ID1 CHAR(2), AC1_DESC VARCHAR(55));

#
#SQL> describe AC_CODE2
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID2                                   CHAR(1)
# AC2_DESC                                 VARCHAR2(15)

create table AC_CODE2 (AC_ID2 CHAR(1), AC2_DESC VARCHAR(15));

#
#SQL> describe AC_CODE3
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID3                                   CHAR(3)
# AC3_DESC                                 VARCHAR2(30)

create table AC_CODE3 (AC_ID3 CHAR(3), AC3_DESC VARCHAR(30));

#
#SQL> describe AC_CODE4
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID4                                   CHAR(3)
# AC4_DESC                                 VARCHAR2(15)

create table AC_CODE4 (AC_ID4 CHAR(3), AC4_DESC VARCHAR(15));

#
#SQL> describe AC_CODE5
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID1                                   CHAR(2)
# AC_ID2                                   CHAR(1)
# AC_ID3                                   CHAR(3)
# AC_ID4                                   CHAR(3)
# AC_ID5                                   CHAR(3)
# AC5_DESC                                 VARCHAR2(40)

create table AC_CODE5 (
	AC_ID1 CHAR(2), 
	AC_ID2 CHAR(1), 
	AC_ID3 CHAR(3), 
	AC_ID4 CHAR(3), 
	AC_ID5 CHAR(3), 
	AC5_DESC VARCHAR(40)
);

#
#SQL> describe CUFL_INFO
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID4                                  CHAR(3)
# OPEN_DT                                  DATE
# STATUS                                   CHAR(1)
# EMP_OPBAL                                NUMBER
# EMP_OPINT                                NUMBER
# TOTCONT                                  NUMBER

create table CUFL_INFO (
	EMP_ID4 CHAR(3), 
	OPEN_DT DATE, 
	STATUS CHAR(1),
	EMP_OPBAL DOUBLE,
	EMP_OPINT DOUBLE,
	TOTCONT DOUBLE
);

#
#SQL> describe CUF_LOAN
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID3                                  CHAR(3)
# LOAN_DT                                  DATE
# LOAN_START                               DATE
# LOAN_END                                 DATE
# LOAN_AMT                                 NUMBER
# INT_AMT                                  NUMBER
# TOT_AMT                                  NUMBER
# INST_NO                                  NUMBER
# INT_RATE                                 NUMBER

create table CUF_LOAN (
	EMP_ID3 CHAR(3),
	LOAN_DT DATE,
	LOAN_START DATE,
	LOAN_END DATE,
	LOAN_AMT DOUBLE,
	INT_AMT DOUBLE,
	TOT_AMT DOUBLE,
	INST_NO DOUBLE,
	INT_RATE DOUBLE
);

#
#SQL> describe DEPT
# Name                            Null?    Type
# ------------------------------- -------- ----
# DEPT_ID                                  CHAR(3)
# DEPT_NAME                                VARCHAR2(30)
# PCT                                      NUMBER

create table DEPT (
	DEPT_ID CHAR(3),
	DEPT_NAME VARCHAR(30),
	PCT DOUBLE
);

#
#SQL> describe DESIG
# Name                            Null?    Type
# ------------------------------- -------- ----
# DESIG_ID                        NOT NULL CHAR(3)
# DESIG_DESC                      NOT NULL VARCHAR2(40)

create table DESIG (
	DESIG_ID CHAR(3) NOT NULL,
	DESIG_DESC VARCHAR(40) NOT NULL
);

#
#SQL> describe EMP_SAL
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID3                         NOT NULL CHAR(3)
# ID_TP                           NOT NULL CHAR(1)
# SAL_ID                          NOT NULL CHAR(3)
# SAL_AMT                         NOT NULL NUMBER(10,2)

create table EMP_SAL (
	EMP_ID3 CHAR(3) NOT NULL,
	ID_TP CHAR(1) NOT NULL,
	SAL_ID CHAR(3) NOT NULL,
	SAL_AMT Double NOT NULL
);

#
#SQL> describe PERSONAL
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID3                         NOT NULL CHAR(3)
# EMP_NAME                        NOT NULL VARCHAR2(40)
# DESIG_ID                        NOT NULL CHAR(3)
# STATUS                          NOT NULL CHAR(1)
# AC_NO                                    VARCHAR2(20)
# EMP_ID2                                  CHAR(3)
# CONF_DT                                  DATE

create table PERSONAL (
	EMP_ID3 CHAR(3) NOT NULL,
	EMP_NAME VARCHAR(40) NOT NULL,
	DESIG_ID CHAR(3) NOT NULL,
	STATUS CHAR(1) NOT NULL,
	AC_NO VARCHAR(20),
	EMP_ID2 CHAR(3),
	CONF_DT DATE
);

#
#SQL> describe PF_INFO
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID4                                  CHAR(3)
# OPEN_DT                                  DATE
# STATUS                                   CHAR(1)
# EMP_OPBAL                                NUMBER
# COMP_OPBAL                               NUMBER
# EMP_OPINT                                NUMBER
# TOTCONT                                  NUMBER
# COMP_INT                                 NUMBER
# TOTINT                                   NUMBER
# INTRATE                                  NUMBER

create table PF_INFO (
	EMP_ID4 CHAR(3),
	OPEN_DT DATE,
	STATUS CHAR(1),
	EMP_OPBAL DOUBLE,
	COMP_OPBAL DOUBLE,
	EMP_OPINT DOUBLE,
	TOTCONT DOUBLE,
	COMP_INT DOUBLE,
	TOTINT DOUBLE,
	INTRATE DOUBLE
);

#
#SQL> describe PF_LOAN
# Name                            Null?    Type
# ------------------------------- -------- ----
#EMP_ID3                                  CHAR(3)
# LOAN_DT                                  DATE
# LOAN_START                               DATE
# LOAN_END                                 DATE
# LOAN_AMT                                 NUMBER
# INT_AMT                                  NUMBER
# TOT_AMT                                  NUMBER
# INST_NO                                  NUMBER
# INT_RATE                                 NUMBER

create table PF_LOAN (
	EMP_ID3 CHAR(3),
	LOAN_DT DATE,
	LOAN_START DATE,
	LOAN_END DATE,
	LOAN_AMT DOUBLE,
	INT_AMT DOUBLE,
	TOT_AMT DOUBLE,
	INST_NO DOUBLE,
	INT_RATE DOUBLE
);

#
#SQL> describe SAL_ID
# Name                            Null?    Type
# ------------------------------- -------- ----
# SAL_ID                          NOT NULL CHAR(3)
# SAL_DESC                        NOT NULL VARCHAR2(30)
# ID_TP                           NOT NULL CHAR(1)

create table SAL_ID (
	SAL_ID CHAR(3) NOT NULL,
	SAL_DESC VARCHAR(30) NOT NULL,
	ID_TP CHAR(1) NOT NULL
);

#
#SQL> describe TEMP_SAL
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID3                                  CHAR(3)
# BASIC                                    NUMBER
# H_RENT                                   NUMBER
# M_ALLOW                                  NUMBER
# C_ALLOW                                  NUMBER
# O_ALLOW                                  NUMBER
# PF                                       NUMBER
# GAS                                      NUMBER
# RENT                                     NUMBER
# CUP                                      NUMBER
# CUFL                                     NUMBER
# W_FUND                                   NUMBER
# ELECT                                    NUMBER
# OTHER                                    NUMBER
# TAX                                      NUMBER
# ARREAR                                   NUMBER
# PF_LOAN                                  NUMBER

create table TEMP_SAL (
	EMP_ID3 CHAR(3),
	BASIC DOUBLE,
	H_RENT DOUBLE,
	M_ALLOW DOUBLE,
	C_ALLOW DOUBLE,
	O_ALLOW DOUBLE,
	PF DOUBLE,
	GAS DOUBLE,
	RENT DOUBLE,
	CUP DOUBLE,
	CUFL DOUBLE,
	W_FUND DOUBLE,
	ELECT DOUBLE,
	OTHER DOUBLE,
	TAX DOUBLE,
	ARREAR DOUBLE,
	PF_LOAN DOUBLE
);

#
#SQL> describe TRANS
# Name                            Null?    Type
# ------------------------------- -------- ----
# VR_NO                           NOT NULL CHAR(5)
# VR_DT                           NOT NULL DATE
# VR_TP                           NOT NULL CHAR(2)
# AC_ID1                          NOT NULL CHAR(2)
# AC_ID2                          NOT NULL CHAR(1)
# AC_ID3                          NOT NULL CHAR(3)
# AC_ID4                          NOT NULL CHAR(3)
# AC_ID5                          NOT NULL CHAR(3)
# DR_CR                                    CHAR(1)
# CHQ_NO                                   VARCHAR2(20)
# AMOUNT                                   NUMBER
# PARTY                                    VARCHAR2(25)
# REMARKS                                  VARCHAR2(40)
# TDATE                                    DATE
# DEPT                                     CHAR(3)

create table TRANS (
	VR_NO CHAR(5) NOT NULL,
	VR_DT DATE NOT NULL,
	VR_TP CHAR(2) NOT NULL,
	AC_ID1 CHAR(2) NOT NULL,
	AC_ID2 CHAR(1) NOT NULL,
	AC_ID3 CHAR(3) NOT NULL,
	AC_ID4 CHAR(3) NOT NULL,
	AC_ID5 CHAR(3) NOT NULL,
	DR_CR CHAR(1),
	CHQ_NO VARCHAR(20),
	AMOUNT DOUBLE,
	PARTY VARCHAR(25),
	REMARKS VARCHAR(40),
	TDATE DATE,
	DEPT CHAR(3)
);

#
#SQL> describe WF_INFO
# Name                            Null?    Type
# ------------------------------- -------- ----
# EMP_ID4                                  CHAR(3)
# OPEN_DT                                  DATE
# STATUS                                   CHAR(1)
# EMP_OPBAL                                NUMBER
# EMP_OPINT                                NUMBER
# TOTCONT                                  NUMBER

create table WF_INFO (
	EMP_ID4 CHAR(3),
	OPEN_DT DATE,
	STATUS CHAR(1),
	EMP_OPBAL DOUBLE,
	EMP_OPINT DOUBLE,
	TOTCONT DOUBLE
);

#
#SQL> describe ADV_TEMP
# Name                            Null?    Type
# ------------------------------- -------- ----
# AC_ID1                                   CHAR(2)
# AC_ID2                                   CHAR(1)
# AC_ID3                                   CHAR(3)
# AC_ID4                                   CHAR(3)
# AC_ID5                                   CHAR(3)
# DR_BAL                                   NUMBER

create table ADV_TEMP (
	AC_ID1 CHAR(2),
	AC_ID2 CHAR(1),
	AC_ID3 CHAR(3),
	AC_ID4 CHAR(3),
	AC_ID5 CHAR(3),
	DR_BAL DOUBLE
);

#
#SQL> spool off
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.