TM ERD
Tables (7)
BELIEVER
- ID — BIGINT — Primary key — NOT NULL
- NAME — VARACHAR
- DHARMA_NAME — VARCHAR
- DATE_OF_BIRTH — VARCHAR(6)
- ADDRESS — VARCHAR
- LUNAR_SOLAR_TYPE — BIT
- PAYMENT_ID — BIGINT
CODE
- ID — BIGINT — Primary key — NOT NULL
- PARENT_ID — BIGINT
- NAME — VARCHAR
- ATT1 — VARCHAR
- ATT2 — VARCHAR
- ATT3 — VARCHAR
- ATT4 — VARCHAR
- ATT5 — VARCHAR
EXPENDITURE_DETAIL
- ID — BIGINT — Primary key — NOT NULL
- PAYMENT_ID — BIGINT — Foreign key → PAYMENT.ID — NOT NULL
- EXPENDITURE_CODE_ID — BIGINT — Foreign key → CODE.ID — NOT NULL
- PAYMENT_AMOUNT1 — BIGINT
- PAYMENT_AMOUNT2 — BIGINT
- PAYMENT_AMOUNT3 — BIGINT
FAMILY
- ID — BIGINT — Primary key — NOT NULL
- BELIEVER_ID — BIGINT — Foreign key → BELIEVER.ID — NOT NULL
- NAME — VARACHAR
- DHARMA_NAME — VARCHAR
- DATE_OF_BIRTH — VARCHAR(6)
- LUNAR_SOLAR_TYPE — BIT
INCOME_DETAIL
- ID — BIGINT — Primary key — NOT NULL
- PAYMENT_ID — BIGINT — Foreign key → PAYMENT.ID — NOT NULL
- INCOME_CODE_ID — BIGINT — Foreign key → CODE.ID — NOT NULL
- PAYMENT_AMOUNT1 — BIGINT
- PAYMENT_AMOUNT2 — BIGINT
- PAYMENT_AMOUNT3 — BIGINT
PAYMENT
- ID — BIGINT — Primary key — NOT NULL
- BELIEVER_ID — BIGINT — Foreign key → BELIEVER.ID — NOT NULL
- PAYMENT_DATE — DATETIME
PRAYER
- ID — BIGINT — Primary key — NOT NULL
- BELIEVER_ID — BIGINT — Foreign key → BELIEVER.ID — NOT NULL
- START_DATE — DATETIME
- END_DATE — DATETIME
- PRAYER_CODE_ID — BIGINT — Foreign key → CODE.ID — NOT NULL