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