DDD
Tables (8)
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_desk_setting
- user_id — int — NOT NULL
- desk_setting_id — int — NOT NULL
- setting_number — int — NOT NULL
user_status
- id — int — Primary key — NOT NULL — AUTO INCREMENT
- status — varchar(20) — NOT NULL