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)