spectacle

Tables (3)

member

  • Member_no (memno) — varchar2(20) — Primary key — NOT NULL
  • email — varchar2(30)
  • position — varchar2(10)
  • name — varchar2(10)
  • password — varchar2(10)

state

  • Member_no (memno) — varchar2(20) — Primary key — NOT NULL
  • Member_no (memno2) — varchar2(20) — Foreign key → member.Member_no — NOT NULL
  • Work_date (workdate) — date
  • Start_time (starttime) — date
  • Finish_time (finishtime) — date

week_state

  • Member_no (memno) — varchar2(20) — Primary key — NOT NULL
  • Member_no (memno2) — varchar2(20) — Foreign key → member.Member_no — NOT NULL
  • Year (Field) — varchar2(4)
  • Month (month) — varchar2(2)
  • Order (order) — number
  • time