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