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