gimal

Tables (4)

Item (아이템)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — DATE
  • Field4 — VARCHAR
  • Field5 — VARCHAR

Loan (대출)

  • Key — INT — Primary key — NOT NULL
  • Field — DATE
  • Field2 — DATE
  • Key (Key2) — INT — Foreign key → Item.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → Staff.Key — NOT NULL
  • Key (Key4) — INT — Foreign key → Member.Key — NOT NULL

Member (회원)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR

Staff (직원)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2