스케줄표

테이블 (3)

schedule_dtl (Untitled2)

  • schedule_code — int — 기본 키 — NOT NULL
  • title — varchar
  • content — varchar
  • year — int
  • month — int
  • date — int
  • time — varchar

shcedule_mst (Untitled3)

  • schdule_mst_code — 기본 키 — NOT NULL
  • user_code — 외래 키 → user_mst.user_code — NOT NULL
  • schedule_code — int — 외래 키 → schedule_dtl.schedule_code — NOT NULL
  • Field

user_mst (Untitled)

  • user_code — 기본 키 — NOT NULL
  • user_id
  • user_password
  • user_name
  • user_role
  • create_date
  • update_date