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