BWP

테이블 (6)

게시글 (article)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → 유저정보.Key — NOT NULL
  • Field (item_id) — BIGINT — NOT NULL
  • Field (type) — INT
  • Field (title) — VARCHAR(100)
  • Field (content) — VARCHAR(100)
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

댓글 (comment)

  • Key (id) — BIGINT — 기본 키
  • Key (user_id) — BIGINT — 외래 키 → 유저정보.Key — NOT NULL
  • Key (article_id) — BIGINT — 외래 키 → 게시글.Key — NOT NULL
  • Field (parent_id) — BIGINT
  • Field (content) — VARCHAR(100)
  • Field (comment_order) — INT
  • Field (comment_depth) — INT
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

상품정보 (item)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(100)
  • Key (company_id) — BIGINT — 외래 키 → 회사정보.Key — NOT NULL
  • Field (price) — BIGINT
  • Field (roasting_point) — VARCHAR(100)
  • Field (origin) — VARCHAR(100)
  • Field (memo) — VARCHAR(100)
  • Field (thumbnail_image) — VARCHAR(255)
  • Field (info_image) — VARCHAR(255)
  • Field (stock) — BOOLEAN
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

유저정보 (user_account)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(100)
  • Field (pw) — VARCHAR(100)
  • Field (nickname) — VARCHAR(100)
  • Field (address) — VARCHAR(100)
  • Field (phone) — VARCHAR(100)
  • Field (notice) — BIGINT
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

주문 (order)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (item_id) — BIGINT — 외래 키 → 상품정보.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → 유저정보.Key — NOT NULL
  • Field2 (item_count) — BIGINT
  • Field2 (order_step) — INT
  • Field (option_grinding) — INT
  • Field (option_weight) — INT
  • Field2 (created_at) — DATETIME
  • Field (modified_at) — DATETIME

회사정보 (company)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (admin_id) — BIGINT — 외래 키 → 유저정보.Key — NOT NULL
  • Field (name) — VARCHAR(100)