관상어분양
테이블 (9)
Copy Of Untitled (CopyOftradeImage)
- Key (tradeimage_id) — 기본 키 — NOT NULL
- Key (communitypost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (url)
Untitled (User)
- Key (user_id) — INT — 기본 키 — NOT NULL
- Field (loginid) — VARCHER(12)
- Field (password) — VARCHER(20)
- Field (nickname) — VARCHER(8)
- Field (name) — VARCHER(6)
- Field (phone) — VARCHER(11)
- Field (user_area) — VARCHER(20)
Untitled (TradePosts)
- Key (tradepost_id) — INT — 기본 키 — NOT NULL
- Key (user_Id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (type)
- Field (status)
- Field2 (area)
- Field (title) — VARCHER(20)
- Field (price)
- Field (views)
- Field (content)
- Field (favoriteposts)
- Field (category)
Untitled (CommunityPosts)
- Key (communitypost_id) — INT — 기본 키 — NOT NULL
- Key (user_Id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (communitypost_title)
- Field (content)
- Field (category)
Untitled (FavoritePosts)
- Key (favoritepost_id) — 기본 키 — NOT NULL
- Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (tradepost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
Untitled (Chat)
- Key (chat_id) — 기본 키 — NOT NULL
- Key (trade_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (seller)
- Field (buyer)
Untitled (tradeImage)
- Key (tradeimage_id) — 기본 키 — NOT NULL
- Key (tradepost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (url)
Untitled (Message)
- Key (message_id) — 기본 키 — NOT NULL
- Key (chat_id) — 외래 키 → Untitled.Key — NOT NULL
- Field (message)
- Field (read_or_not)
- Field (sender_id)
Untitled (comment)
- Key (comment_id) — 기본 키 — NOT NULL
- Key (user_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Key (communitypost_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (content)