[offtopic] free database for NGO in Bangladesh
I'm not sure if it's send properly ....
------------------------------------------------------------------
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
Reply to: