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)