asdasd
Tables (8)
Business
- BUS_TYPE — INT — Primary key — NOT NULL
- BUS_NAME — VARCHAR(255) — NOT NULL
- BUS_TPYE — VARCHAR(50)
- BUS_CON — VARCHAR(50)
- BUS_ADD — VARCHAR(255)
- BUS_YEAR — INT
- EMP_NUM — INT
- BUS_WEB — VARCHAR(255)
- BUS_HEAD — VARCHAR(255)
- SUP_ID — VARCHAR(255) — Foreign key → Untitled2.SUP_ID — NOT NULL
Department
- DEP_ID — INT — Primary key — NOT NULL
- DEP_CON — VARCHAR(50)
- DEP_LOC — VARCHAR(255)
- DEP.HEAD — VARCHAR(100)
- DEP.YEAR — INT
- DEP_NAME — VARCHAR(255) — NOT NULL
- RET_ID — INT — Foreign key → Untitled4.RET_ID — NOT NULL
Policy_Fund
- FUND_ID — INT — Primary key — NOT NULL
- FUND_TYPE — VARCHAR(100)
- FUND_AMT — DECIMAL(15, 2)
- FUND_DATE — DATE
- FUND_DEC — TEXT
- FUND_EC — TEXT
- FUND_DEAD — DATE
- ALLOC_ID — INT — Foreign key → Untitled.ALLOC_ID — NOT NULL
Repayment
- REP_ID — INT — Primary key — NOT NULL
- REP_DATE — DATE
- REP_AMT — DECIMAL(15, 2)
- REP_STAT — VARCHAR(50)
- REP_RATE — DECIMAL(5, 2)
- REP_MAT — VARCHAR(50)
- SREP_ID — VARCHAR(255) — Foreign key → Untitled3.SREP_ID — NOT NULL
Untitled
- ALLOC_ID — INT — Primary key — NOT NULL
- DEP_ID — INT — Foreign key → Department.DEP_ID — NOT NULL
Untitled2
- SUP_ID — VARCHAR(255) — Primary key — NOT NULL
- FUND_ID — INT — Foreign key → Policy_Fund.FUND_ID — NOT NULL
Untitled3
- SREP_ID — VARCHAR(255) — Primary key — NOT NULL
- BUS_TYPE — INT — Foreign key → Business.BUS_TYPE — NOT NULL
Untitled4
- RET_ID — INT — Primary key — NOT NULL
- REP_ID — INT — Foreign key → Repayment.REP_ID — NOT NULL