boostcamp_p1

Tables (3)

EXPENSE (CopyOfCopyOfUntitled)

  • Ekey — INT — Primary key — NOT NULL — auto_increment
  • Tkey — INT — Foreign key → TRANSLATION.Tkey — NOT NULL — auto_increment
  • Pay_type — VARCHAR(10) — NOT NULL

INCOME (CopyOfUntitled)

  • Ikey — INT — Primary key — NOT NULL — auto_increment
  • Tkey — INT — Foreign key → TRANSLATION.Tkey — NOT NULL — auto_increment
  • Income_type — VARCHAR(10) — NOT NULL

TRANSLATION (Untitled)

  • Tkey — INT — Primary key — NOT NULL — auto_increment
  • Date — DATE — NOT NULL
  • Type — VARCHAR(10) — NOT NULL
  • Content — VARCHAR(30) — NOT NULL
  • Price — BIGINT — NOT NULL