ERD - 2024-07-31 03:45:10
테이블 (7)
ChatMessage (Untitled4)
- message_seq (Key) — BIGINT — 기본 키 — NOT NULL — Increasement
- user_seq (Key4) — BIGINT — 외래 키 → user.user_seq — NOT NULL
- room_seq (Key3) — BIGINT — 외래 키 → ChatRoom.room_seq — NOT NULL
- message_type (Field) — VARCHAR — NOT NULL
- message (Field2) — VARCHAR — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
ChatRoom (Untitled2)
- room_seq (Key) — BIGINT — 기본 키 — NOT NULL — Increasement
- user_seq (Key2) — BIGINT — 외래 키 → user.user_seq — NOT NULL — Increasement
- room_title (Field) — VARCHAR — NOT NULL
- delivery_time (Field2) — DATETIME — NOT NULL
- category (Field3) — ENUM — NOT NULL
- created_at (Field4) — DATETIME — NOT NULL
- pickup_place (Field5) — VARCHAR — NOT NULL
- pickup_lat (Field9) — DECIMAL — NOT NULL
- pickup_lon (Field8) — DECIMAL — NOT NULL
- status (Field6) — ENUM — NOT NULL
- notice (Field7) — VARCHAR
ChatUser (Untitled3)
- chat_user_seq (Key2) — BIGINT — 기본 키 — NOT NULL — Increasement
- room_seq (Key4) — BIGINT — 외래 키 → ChatRoom.room_seq — NOT NULL
- user_seq (Key) — BIGINT — 외래 키 → user.user_seq — NOT NULL
- join_time (Field) — DATETIME — NOT NULL
account
- account_seq (PK) — 기본 키 — NOT NULL — Increasment
- user_seq (Key) — BIGINT — 외래 키 → user.user_seq — NOT NULL
- main (Field) — Boolean — NOT NULL — 메인 결제 계좌 여부
member
- member_seq (Key) — BIGINT — 기본 키 — NOT NULL — Increasement
- party_seq (Key4) — BIGINT — 외래 키 → party ( 정산현황 ).party_seq — NOT NULL — Increasement
- user_seq (Key2) — BIGINT — 외래 키 → user.user_seq — NOT NULL — Increasement
- cost (Field) — INT — NOT NULL — 개인비용
- status (Field4) — BOOLEAN — NOT NULL — 정산여부
- is_leader (Field2) — BOOLEAN — NOT NULL — 리더여부
- created_at (Field5) — datetime — NOT NULL
party ( 정산현황 ) (party)
- party_seq (Key) — BIGINT — 기본 키 — NOT NULL — Increasement
- title (Field5) — VARCHAR
- cost (Field3) — INT — NOT NULL
- status (Field4) — Boolean — NOT NULL
- created_at (Field6) — DATETIME — NOT NULL
- count (Field) — INT — NOT NULL — 돈 낸 사람수
- total_member (Field7) — INT — NOT NULL — 파티 인원수
user
- user_seq (Key) — BIGINT — 기본 키 — NOT NULL — Increasement
- user_id (Field) — VARCHAR — NOT NULL
- user_name (Field2) — VARCHAR — NOT NULL
- phone_number (Field6) — VARCHAR — NOT NULL
- birth (Field3) — DATETIME — NOT NULL
- created_at (Field7) — dattime — NOT NULL
- alarm (Field9) — BOOLEAN — NOT NULL
- sido (Field10) — VARCHAR — NOT NULL
- gugun (Field11) — VARCHAR — NOT NULL
- addr (Field12) — VARCHAR — NOT NULL
- lat (Field13) — DECIMAL — NOT NULL
- lng (Field14) — DECIMAL — NOT NULL
- img_no (Field15) — INT — NOT NULL — 0~20
- gender (Field16) — ENUM — NOT NULL — "F" or "M"