빌링
테이블 (5)
Untitled (User)
- uid (Key) — 기본 키 — NOT NULL
- Field (user_id)
- Field2 (kakao_id)
- Field3 (nickname)
- Field (profile_image)
- Field2 (introduction)
- Field3 (location)
- Field4 (tier)
Untitled (Board)
- Key — 기본 키 — NOT NULL
- Field (board_id)
- Field2 (user_id)
- Field3 (title)
- Field4 (content)
- Field5 (category)
- Field6 (price)
- Field7 (photo)
- Field8 (location) — INT
- Field (location_rental)
- Field (period)
- uid (Key2) — 외래 키 → Untitled.uid — NOT NULL
Untitled (Chat)
- Key — 기본 키 — NOT NULL
- Field (chat_id)
- Field2 (board_id)
- Field3 (sender_id)
- Field4 (unread) — INT
- Key (Key3) — 외래 키 → Untitled.Key — NOT NULL
- uid (Key4) — 외래 키 → Untitled.uid — NOT NULL
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Message)
- Key — 기본 키 — NOT NULL
- Field (message_id)
- Field2 (chat_id)
- Field3 (sender_id)
- Field4 (content)
- Field5 (읽음 or 안읽음?)
Untitled (Review)
- Key — 기본 키 — NOT NULL
- Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
- Field (review_id)
- Field2 (board_id)
- Field3 (reviewer_id)
- Field4 (reviewee_id)
- Field5 (rating)
- Field (comment)
- uid (Key3) — 외래 키 → Untitled.uid — NOT NULL