Secondhand Online Shop
Tables (5)
Chat (채팅내역)
- metaId (채팅정보아이디) — int64 — Foreign key → ChatMeta.id — NOT NULL
- timeStamp (타임스탬프) — datetime — 얘까지 복합 pk
- userId (유저아이디(발화자)) — int64
- Field — text
ChatMeta (채팅정보)
- id (채팅아이디) — int64 — Primary key — NOT NULL
- userId1 (유저아이디1) — int64
- userId2 (유저아이디2) — int64
- itemId (상품아이디) — int64
Item (상품)
- id (상품아이디) — int64 — Primary key — NOT NULL
- userId (유저아이디) — int64 — Foreign key → User.id — NOT NULL
- title (상품명) — text
- description (상품설명) — text
- price (판매가격) — int32
- state (판매상태) — int8
Like (찜)
- userid (유저아이디) — int64 — Foreign key → User.id — NOT NULL
- itemId (상품아이디) — int64 — Foreign key → Item.id — NOT NULL
User (사용자)
- id (유저아이디) — int64 — Primary key — NOT NULL
- nickname (유저닉네임) — text
- password (패스워드) — text