Todolist

테이블 (9)

Untitled (BaseEntity)

  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (member_images)

  • Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
  • Field (name) — varchar(50)
  • Field (type) — enum('JPG', 'JPEG', 'PNG')

Untitled (tasks)

  • Key (task_id) — bigint — 기본 키 — NOT NULL
  • Key (task_group_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
  • Field (name) — varchar(30)
  • Field (flag) — boolean
  • Field (status) — enum('BACKLOG', 'COMPLETED', 'CANCLED')
  • Field (order) — int
  • Field (memo) — varchar(500)
  • Field (start_time) — time
  • Field (alarm_time) — time
  • Field (due_date) — date

Untitled (sub_tasks)

  • Key (sub_task_id) — bigint — 기본 키 — NOT NULL
  • Key (task_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(30)
  • Field (status) — enum('BACKLOG', 'COMPLETED', 'CANCLED')
  • Field (order) — int

Untitled (task_categories)

  • Key (task_category_id) — bigint — 기본 키 — NOT NULL
  • Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
  • Key (task_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(30)

Untitled (task_groups)

  • Key (task_group_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(30)

Untitled (oauth2_credentials)

  • Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
  • Field (vendor) — enum('KAKAO')

Untitled (member_settings)

  • Field (member_id) — bigint — 외래 키 → 회원.Field — NOT NULL
  • Field (theme_mode) — enum('LIGHT', 'DARK')

회원 (members)

  • Field (member_id) — bigint — 기본 키 — NOT NULL
  • Field (username) — varchar(20)
  • Field (password) — varchar(20)
  • Field (nickname) — varchar(10)