scheduler
Tables (4)
account (Untitled)
- user_idx (PK) — int — Primary key — NOT NULL — Auto Increment, PK, FK
- department (Key2) — varchar(10) — Foreign key → department.name — NOT NULL — FK
- id (Field) — varchar(15) — NOT NULL — UNIQUE
- pw (Field2) — varchar(40) — NOT NULL
- name (Field8) — varchar(15) — NOT NULL
- contact (Field3) — varchar(10) — NOT NULL — UNIQUE
- role (Field5) — enum(팀장, 팀원) — NOT NULL — 둘 중 하나만 허용
- create_at (Field6) — timestamp — NOT NULL
- update_at (Field7) — timestamp — NOT NULL
department (Untitled2)
- idx (Key) — int — Primary key — NOT NULL — Auto Increment, PK
- name (Key2) — enum(경영팀, 디자인팀) — Primary key — NOT NULL — FK
role (Untitled4)
- idx (Key) — int — Primary key — NOT NULL — Auto Increment, PK, FK
- Field — varchar(10) — NOT NULL
schedule (Untitled3)
- idx (Key) — Auto Increment, PK — Primary key — NOT NULL
- user_idx (PK) — int — Foreign key → account.user_idx — NOT NULL — Auto Increment, PK, FK
- date (Field5) — date — NOT NULL
- start_time (Field) — time — NOT NULL
- end_time (Field2) — time — NOT NULL
- content (Field3) — varchar(50) — NOT NULL
- update_at (Field4) — timestamp