couplesync
Tables (7)
anniversaries
- anniversary_id — BIGINT
- couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- anniversary_date — DATE — NOT NULL
- type — VARCHAR(50)
- is_auto_created — BOOLEAN
couple_members
- couple_member_id — BIGINT
- couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- joined_at — DATETIME
couples
- couple_id — BIGINT
- invite_code — VARCHAR(20) — NOT NULL
- start_date — DATE
- created_at — DATETIME
schedule_details
- detail_id — BIGINT
- schedule_id — BIGINT — Foreign key → schedules.schedule_id — NOT NULL
- detail_time — TIME
- content — VARCHAR(255) — NOT NULL
- sort_order — INT
schedules
- schedule_id — BIGINT
- couple_id — BIGINT — Foreign key → couples.couple_id — NOT NULL
- writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- location — VARCHAR(255)
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME
- category — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
todos
- todo_id — BIGINT
- schedule_id — BIGINT — Foreign key → schedules.schedule_id — NOT NULL
- assigned_user_id — BIGINT — Foreign key → users.user_id
- content — VARCHAR(255) — NOT NULL
- is_done — BOOLEAN
- created_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME