ERD_New

Tables (7)

category

  • id — int — Primary key — NOT NULL — AUTO INCREMENT
  • category — varchar(20) — NOT NULL — 카테고리는 유저가 추가 가능

desk_setting

  • id — Long — Primary key — NOT NULL
  • desk_height — Long — NOT NULL
  • monitor_height (chair_height) — Long — NOT NULL
  • desk_index — Long
  • user_id — Long — Foreign key → user.id — NOT NULL — AUTO INCREMENT

priority

  • id — Long — Primary key — NOT NULL — AUTO INCREMENT
  • priority — varchar(20) — NOT NULL — 중요도를 등록

seat

  • id — Long — Primary key — NOT NULL — AUTO INCREMENT
  • is_empty — boolean — NOT NULL
  • seat_number — Long — NOT NULL
  • area — varchar(10) — NOT NULL

todo

  • id — Long — Primary key — NOT NULL — AUTO INCREMENT
  • user_id — Long — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • content — varchar(200)
  • priority_id — Long — NOT NULL
  • category_id — Long — NOT NULL — 디폴트는 "메인 일정"
  • time_to_notice — DATETIME

user

  • id — Long — Primary key — NOT NULL — AUTO INCREMENT
  • account_id — varchar(20) — NOT NULL
  • password — varchar(200) — NOT NULL
  • name — varchar(20) — NOT NULL
  • height — Long
  • email — varchar(50)
  • phone_number — varchar(50)
  • profile_URL — varchar(200)
  • position — varchar(20)
  • employee_number — varchar(20)
  • staus_id — Long — NOT NULL
  • notice_display — boolean
  • notice_sound — boolean
  • notice_vibration — boolean
  • seat_id — Long — Foreign key → seat.id — NOT NULL — AUTO INCREMENT
  • status_id — Long — Foreign key → user_status.id — NOT NULL — AUTO INCREMENT

user_status

  • id — Long — Primary key — NOT NULL — AUTO INCREMENT
  • status — varchar(20) — NOT NULL