boost carrot
Tables (8)
CHAT
- ID — INT — Primary key — NOT NULL
- BUYER_ID — INT — Foreign key → USER.ID — NOT NULL
- POST_ID — INT — Foreign key → POST.IDI — NOT NULL
- SELLER_ID — INT — Foreign key → USER.ID — NOT NULL
CHAT_MESSAGE
- CHAT_ID — INT — Foreign key → CHAT.ID — NOT NULL
- CONTENTS — VARCHAR(500) — NOT NULL
- DATE_CREATED — DATE — NOT NULL
- READ — BOOL — NOT NULL
IMG
- ID — INT — Primary key — NOT NULL
- URL — VARCHAR(50) — NOT NULL
- POST_ID — INT — Foreign key → POST.IDI — NOT NULL
POST
- IDI (ID) — INT — Primary key — NOT NULL
- TITLE — VARCHAR(24) — NOT NULL
- CATEGORY — INT — NOT NULL
- PRICE — INT
- TOWN_ID — INT — Foreign key → TOWN.ID — NOT NULL
- DATE_CREATED — DATE — NOT NULL
- VIEW_CNT — INT — NOT NULL
- SELLER_ID — INT — Foreign key → USER.ID — NOT NULL
- STATE — INT — NOT NULL
- MEMO — VARCHAR(100) — NOT NULL
TOWN
- ID — INT — Primary key — NOT NULL
- NAME — VARCHAR(24) — NOT NULL
USER
- ID — INT — Primary key — NOT NULL
- USER_ID — VARCHAR(50)
- REFRESH_TOKEN — VARCHAR(50)
USER_TOWN
- USER_ID — INT — Foreign key → USER.ID — NOT NULL
- TOWN_ID — INT — Foreign key → TOWN.ID — NOT NULL
- PICKED (Field) — BOOL — NOT NULL
WISH_LIST
- POST_ID — INT — Foreign key → POST.IDI — NOT NULL
- USER_ID — INT — Foreign key → USER.ID — NOT NULL