tt

테이블 (6)

동의서 (Agreement)

  • agreement_id — bigint — 기본 키 — NOT NULL
  • apartment_id — bigint — 외래 키 → 아파트.apartment_id — NOT NULL
  • agreement_title — varchar — NOT NULL
  • agreement_content — varchar — NOT NULL
  • created_at — DATETIME — NOT NULL

동의한 유저 (AgreeUser)

  • agreement_id — bigint — 외래 키 → 동의서.agreement_id — NOT NULL
  • member_id — bigint — 외래 키 → 유저.member_id — NOT NULL
  • Field (agree_check) — boolean — NOT NULL
  • Field (agree_at) — DATETIME

메시지 (Message)

  • message_id — bigint — 기본 키 — NOT NULL
  • message_content — varchar
  • member_id (send_member_id) — bigint — 외래 키 → 유저.member_id — NOT NULL
  • member_id (recive_member_id) — bigint — 외래 키 → 유저.member_id — NOT NULL
  • Field (send_at) — DATETIME — NOT NULL
  • Field (read_at) — DATETIME

아파트 (Apartment (Temp))

  • apartment_id — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar — NOT NULL

아파트 관리자 (ApartManager)

  • Apartment_id (apartment_id) — bigint — 외래 키 → 아파트.apartment_id — NOT NULL
  • member_id — bigint — 외래 키 → 유저.member_id — NOT NULL

유저 (Member (Temp))

  • member_id — bigint — 기본 키 — NOT NULL