todoone
Tables (4)
Calendar (calendar_table)
- calendarId (calendar_id) — BIGINT — Primary key — NOT NULL
- userId (user_id2) — BIGINT — Foreign key → User.userId — NOT NULL
- coupleId (couple_id) — BIGINT — Foreign key → User.coupleId
- dateStart (date_start) — DATE
- dateEnd (date_end) — DATE
- title — VARCHAR
- nickname — VARCHAR
- together — TINYINT
Couple (couple_table)
- coupleId (couple_id) — BIGINT — Primary key — NOT NULL
- userId1 (user_id1) — BIGINT — Foreign key → User.userId — NOT NULL
- userId2 (user_id2) — BIGINT — Foreign key → ToDo.todoId — NOT NULL
ToDo (todo_table)
- todoId (todo_id) — BIGINT — Primary key — NOT NULL
- userId (user_id2) — BIGINT — Foreign key → User.userId — NOT NULL
- coupleId (couple_id) — BIGINT — Foreign key → User.coupleId
- content — VARCHAR
- date — DATE
- completeStatus (complete_status) — TINYINT
- together — TINYINT
User (user_table)
- userId (user_id) — BIGINT — Primary key — NOT NULL
- code — BIGINT — Primary key
- coupleId (couple_id) — BIGINT — Primary key
- name — VARCHAR
- email — VARCHAR
- password — VARCHAR
- birth — DATE
- gender — TINYINT
- allowNotification (allow_notification) — TINYINT
- nickname — VARCHAR