testassignment

Tables (4)

Bank (Untitled)

  • PK (id) — LONG — Primary key — NOT NULL
  • 은행이름 (name) — STRING

BasicAccount (Untitled2)

  • PK (id) — LONG — Primary key — NOT NULL
  • FK (member_id) — LONG — Foreign key → Bank.PK — NOT NULL
  • 계좌종류 (accountType) — AccountType
  • 계좌번호 (accountNumber) — STRING
  • 잔액 (balance) — BigDemical
  • 활성여부 (isActivated) — BOOLEAN

MeetingAccount (Untitled3)

  • FK (member_id) — LONG — Foreign key → Bank.PK — NOT NULL
  • FK (savingAccount_id) — LONG — Foreign key → SavingAccount.PK — NOT NULL

SavingAccount (CopyOfUntitled2)

  • PK (id) — LONG — Primary key — NOT NULL
  • 계좌종류 (accountType) — AccountType
  • 계좌번호 (accountNumber) — STRING
  • 잔액 (balance) — BigDemical
  • 활성여부 (isActivated) — BOOLEAN
  • 목표금액 (Field) — BigDemical