marketCurly

Tables (6)

ITEM (item)

  • ID (id) — BIGINT(20) — Primary key — NOT NULL
  • Key (id2) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • ITEM_NAME (item_name) — VARCHAR(40)
  • CATEGORY (category) — VARCHAR(40)
  • IS_NEW (is_new) — BOOLEAN
  • PRICE (price) — BIGINT(20)
  • DESCRIPTION (descriptioin) — VARCHAR(255)
  • DETAIL (detail) — TEXT
  • STOCK (stock) — BIGINT(20)

REVIEW (review)

  • ID (id) — BIGINT(20) — Primary key — NOT NULL
  • ID (id2) — BIGINT(20) — Foreign key → ITEM.ID — NOT NULL
  • ID (id3) — BiIGINT(20) — Foreign key → USER.ID — NOT NULL
  • Key (id22) — BIGINT(20) — Foreign key → ITEM.Key — NOT NULL
  • Key (id23) — BIGINT(20) — Foreign key → USER.Key — NOT NULL
  • REGISTER_TIME (register_time) — DATETIME
  • DETAIL (content) — TEXT
  • Field (edit_time) — DATETIME
  • Field (title) — VARCHAR(255)

REVIEW_IMG

  • Key (id) — BIGINT(20) — Primary key — NOT NULL
  • ID (id2) — BIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
  • ID (id22) — BIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
  • ID (id3) — BiIGINT(20) — Foreign key → REVIEW.ID — NOT NULL
  • Key (id222) — BIGINT(20) — Foreign key → REVIEW.Key — NOT NULL
  • Key (id23) — BIGINT(20) — Foreign key → REVIEW.Key — NOT NULL
  • Field (img_url) — VARCHAR(255)

USER (user)

  • ID (id) — BiIGINT(20) — Primary key — NOT NULL
  • Key (id2) — BIGINT(20) — Foreign key → Untitled.Key — NOT NULL
  • LOGIN_ID (login_id) — VARCHAR(30)
  • PASSWORD (password) — VARCHAR(40)
  • NICKNAME (nickname) — VARCHAR(30)
  • NAME (name) — VARCHAR(255)
  • BIRTHDAY (birthday) — DATE
  • IS_ADMIN (is_admin) — BOOLEAN
  • REGISTER_TIME (register_time) — DATETIME

Untitled (qna)

  • Key (id) — BIGINT(20) — Primary key — NOT NULL
  • ID (id2) — BiIGINT(20) — Foreign key → USER.ID — NOT NULL
  • ID (id3) — BIGINT(20) — Foreign key → ITEM.ID — NOT NULL
  • Key (id22) — BIGINT(20) — Foreign key → ITEM.Key — NOT NULL
  • Key (id23) — BIGINT(20) — Foreign key → USER.Key — NOT NULL
  • Field (register_time) — DATETIME
  • Field (edit_time) — DATETIME
  • Field (title) — VARCHAR(255)
  • Field (content) — TEXT

Untitled (shopping_bag)

  • Key (id) — BIGINT(20) — Primary key — NOT NULL