test

Tables (5)

code

  • code_id — BIGINT — Primary key — NOT NULL
  • group_code — CHAR(3) — NOT NULL
  • code — CHAR(3) — NOT NULL
  • code_name — VARCHAR(50) — NOT NULL
  • use_yn — CHAR(1)

group_code

  • group_code — CHAR(3) — Primary key — NOT NULL
  • group_code_name — VARCHAR(50) — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • role — ENUM('admin','user')
  • created_at — DATETIME

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • phone_id — BIGINT — NOT NULL
  • order_date — DATETIME
  • quantity — INT — NOT NULL
  • order_regular_price — INT — NOT NULL
  • order_discount_amount — INT — NOT NULL

phone

  • phone_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • code_id — BIGINT — NOT NULL
  • regular_price — INT — NOT NULL
  • discount_amount — INT — NOT NULL
  • stock — INT — NOT NULL
  • is_deleted — TINYINT(1)
  • created_at — DATETIME