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