DDD_new

Tables (7)

category

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

desk_setting

  • id — VARCHAR(255) — Primary key — NOT NULL
  • desk_height — Not — NOT NULL
  • chair_height — Not — NOT NULL

priority

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

seat

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

todo

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

user

  • id — int — Primary key — NOT NULL — AUTO INCREMENT
  • account_id — varchar(20) — NOT NULL
  • password — varchar(200) — NOT NULL
  • name — varchar(20) — NOT NULL
  • height — int
  • email — varchar(50)
  • phone_number — varchar(50)
  • profile_URL — varchar(200)
  • position — varchar(20)
  • employee_number — varchar(20)
  • seat_id — int
  • staus_id — int — NOT NULL
  • notice_display — boolean
  • notice_sound — boolean
  • notice_vibration — boolean

user_status

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