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