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