J-AI 최종

테이블 (12)

alarm

  • alarm_id — binary(16) — NOT NULL
  • is_read — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • description — varchar(800)
  • type — enum — NOT NULL
  • read_time — datetime
  • scheduled_time — datetime
  • is_sent — tinyint(1) — NOT NULL
  • group_event_mapping_id — binary(16) — 외래 키 → group_event_mapping.group_event_mapping_id
  • group_invitation_id — binary(16) — 외래 키 → group_invitation.group_invitation_id
  • personal_event_id — binary(16) — 외래 키 → personal_event.personal_event_id
  • user_id — binary(16) — 외래 키 → users.user_id

category

  • category_id — binary(16) — NOT NULL
  • group_id — binary(16) — 외래 키 → group_tb.group_id
  • user_id — binary(16) — 외래 키 → users.user_id
  • name — varchar(20) — NOT NULL
  • color — varchar(50) — NOT NULL

group_event

  • end_date — date — NOT NULL
  • end_time — time
  • is_alarmed — tinyint(1) — NOT NULL
  • start_date — date — NOT NULL
  • start_time — time
  • created_at — datetime
  • group_event_id — binary(16) — NOT NULL
  • group_id — binary(16) — 외래 키 → group_tb.group_id
  • title — varchar(255) — NOT NULL

group_event_mapping

  • group_event_id — binary(16) — 외래 키 → group_event.group_event_id
  • group_event_mapping_id — binary(16) — NOT NULL
  • group_setting_id — binary(16) — 외래 키 → group_setting.group_setting_id

group_invitation

  • group_invitation_id — binary(16) — NOT NULL
  • description — varchar(255)
  • status — enum — NOT NULL
  • user_id — binary(16) — 외래 키 → users.user_id
  • group_id — binary(16) — 외래 키 → group_tb.group_id

group_setting

  • group_id — binary(16) — 외래 키 → group_tb.group_id
  • group_setting_id — binary(16) — NOT NULL
  • user_id — binary(16) — 외래 키 → users.user_id
  • role — enum — NOT NULL

group_tb

  • group_id — binary(16) — NOT NULL
  • name — varchar(20) — NOT NULL
  • description — varchar(255)

group_todo

  • created_at — datetime — NOT NULL
  • date — date — NOT NULL
  • done — tinyint(1) — NOT NULL
  • start_time — time
  • todo_order — int — NOT NULL
  • group_id — binary(16) — 외래 키 → group_tb.group_id — NOT NULL
  • group_todo_id — binary(16) — NOT NULL
  • title — varchar(255) — NOT NULL

group_todo_mapping

  • done — bit — NOT NULL
  • group_setting_id — binary(16) — 외래 키 → group_setting.group_setting_id — NOT NULL
  • group_todo_id — binary(16) — 외래 키 → group_todo.group_todo_id — NOT NULL
  • group_todo_mapping_id — binary(16) — NOT NULL

personal_event

  • end_date — date — NOT NULL
  • end_time — time
  • is_alarmed — tinyint(1) — NOT NULL
  • start_date — date — NOT NULL
  • start_time — time
  • created_at — datetime — NOT NULL
  • category_id — binary(16) — 외래 키 → category.category_id
  • personal_event_id — binary(16) — NOT NULL
  • user_id — binary(16) — 외래 키 → users.user_id
  • title — varchar(255) — NOT NULL

personal_todo

  • date — date — NOT NULL
  • done — tinyint(1) — NOT NULL
  • start_time — time
  • todo_order — int — NOT NULL
  • created_at — datetime — NOT NULL
  • category_id — binary(16) — 외래 키 → category.category_id — NOT NULL
  • personal_todo_id — binary(16) — NOT NULL
  • user_id — binary(16) — 외래 키 → users.user_id — NOT NULL
  • title — varchar(255) — NOT NULL

users

  • end_time — time — NOT NULL
  • user_id — binary(16) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • email — varchar(50) — NOT NULL
  • image_url — varchar(500)
  • passsword — varchar(255) — NOT NULL
  • provider — enum — NOT NULL
  • role — varchar(20)