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"