Together
테이블 (7)
게시글 (Post)
- post id (id) — BIGINT — 기본 키 — NOT NULL
- user id (user_id) — BIGINT — 외래 키 → 유저.user id — NOT NULL
- couple id (couple_id) — BIGINT — 외래 키 → 유저.couple id — NOT NULL
- imageUrl — VARCHAR
- description — TEXT
- post created date (created_date_time) — DATETIME
- post modified date (modified_date_time) — DATETIME
- post deleted date time (deleted_date_time) — DATETIME
댓글 (Comment)
- comment id (id) — BIGINT — 기본 키 — NOT NULL
- post id (post_id) — BIGINT — 외래 키 → 게시글.post id — NOT NULL
- user id (user_id) — BIGINT — 외래 키 → 게시글.user id — NOT NULL
- couple id (couple_id) — BIGINT — 외래 키 → 게시글.couple id — NOT NULL
- description — TEXT
- comment created_date (created_date_time) — DATETIME
- comment modified_date (modified_date_time) — DATETIME
- comment deleted date (deleted_date_time) — DATETIME
사진 (photo)
- photo id (id) — BIGINT — 기본 키 — NOT NULL
- user id (user_id) — BIGINT — 외래 키 → 유저.user id — NOT NULL
- couple id (couple_id) — BIGINT — 외래 키 → 유저.couple id — NOT NULL
- imageUrl — VARCHAR
- photo created date time (created_date_time) — DATETIME
유저 (User)
- user id (id) — BIGINT — 기본 키 — NOT NULL
- couple id (couple_id) — BIGINT — 외래 키 → 커플.couple id — NOT NULL
- user password for login (password) — VARCHAR
- user created date_time (created_date_time) — DATETIME
- user modified date time (modified_date_time) — DATETIME
- username for login (username) — VARCHAR
채팅 (chat)
- chat id (id) — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR — 외래 키 → 유저.user id — NOT NULL
- couple id (couple_id2) — BIGINT — 외래 키 → 유저.couple id — NOT NULL
- imageUrl (image_url) — VARCHAR
- content — TEXT
- chat created date time (created_date_time) — DATETIME
커플 (Couple)
- couple id (couple_id) — BIGINT — 기본 키 — NOT NULL
- couple created date time (created_date_time) — DATETIME
- couple modified date time (modified_date_time) — DATETIME
- authorized — BOOLEAN
활동로그 (history)
- history id (id) — BIGINT — 기본 키 — NOT NULL
- user id (user_id) — BIGINT — 외래 키 → 유저.user id — NOT NULL
- couple id (couple_id) — BIGINT — 외래 키 → 유저.couple id — NOT NULL
- target id (target_id) — BIGINT
- history type (history_type) — VARCHAR
- history action (history_action) — VARCHAR
- created datetime (created_date_time) — DATETIME
- post content (post_content) — TEXT
- comment content (comment_content) — TEXT