ACON

테이블 (5)

Untitled (product_info)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (partner_id) — BIGINT — 외래 키 → 회원.Key — NOT NULL
  • Field (price) — INT
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field2 (updatedAt) — TIMESTAMP — NOT NULL
  • Field3 (deleted) — BOOLEAN — NOT NULL

Untitled (completed_product_details)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (product_info_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (language_type) — TINYINT — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field2 (createdAt) — TIMESTAMP — NOT NULL
  • Field3 (updatedAt) — TIMESTAMP — NOT NULL
  • Field4 (deleted) — BOOLEAN — NOT NULL

Untitled (product_details_history)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (product_info_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (product_status) — TINYINT — NOT NULL
  • Field (language_type) — TINYINT — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (content) — TEXT
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field2 (updatedAt) — TIMESTAMP — NOT NULL
  • Field3 (deleted) — BOOLEAN — NOT NULL

Untitled (product_notes)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (product_history_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (member_id) — BIGINT — 외래 키 → 회원.Key — NOT NULL
  • Field (type) — TINYINT — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (content) — TEXT — NOT NULL
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field (updatedAt) — TIMESTAMP — NOT NULL
  • Field (deleted) — BOOLEAN — NOT NULL

회원 (member)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(255) — NOT NULL
  • Field2 (password) — VARCHAR(255) — NOT NULL
  • Field (type) — TINYINT — NOT NULL
  • Field (name) — VARCHAR(100)
  • Field (phone_number) — VARCHAR(15)
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field2 (updatedAt) — TIMESTAMP — NOT NULL
  • Field (deleted) — BOOLEAN — NOT NULL