mall

Tables (12)

Auth

  • auth_id — NOT NULL — Primary key — NOT NULL
  • type — NOT NULL — NOT NULL
  • role — NOT NULL — NOT NULL

Invoice

  • invoice_id — NOT NULL,UNIQUE — Primary key — NOT NULL
  • invoice_code — VARCHAR(100) — NOT NULL
  • invoice_company — VARCHAR(100) — NOT NULL
  • invoice_date — DATETIME

Members

  • user_id — NOT NULL — Primary key — NOT NULL
  • auth_id — NOT NULL — Foreign key → Auth.auth_id — NOT NULL
  • password — NOT NULL — NOT NULL
  • username — NOT NULL — NOT NULL
  • age — NOT NULL
  • gender — ENUM('M', 'F', 'O')
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • address — TEXT — NOT NULL
  • enter_date — DATETIME
  • modify_date — DATETIME
  • user_status — ENUM('M', 'F', 'O') — NOT NULL

cart

  • cart_id — INT — Primary key — NOT NULL
  • product_id — INT — Foreign key → product.product_id — NOT NULL
  • category_id — INT — Foreign key → category.category_id — NOT NULL
  • quantity — INT — NOT NULL
  • is_pay — ENUM('Y', 'N') — NOT NULL

category

  • category_id — NOT NULL,UNIQUE — Primary key — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL

coupon

  • coupon_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → Members.user_id — NOT NULL
  • auth_id — INT — Foreign key → Members.auth_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • discount — DECIMAL(10, 2) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • status — ENUM('Y', 'N') — NOT NULL

order

  • order_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → Members.user_id — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • regist_date — DATETIME
  • addressee — VARCHAR(100) — NOT NULL
  • address — TEXT — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • Field

pay_bank

  • bank_id — NOT NULL — Primary key — NOT NULL
  • pay_id (pay_id2) — NOT NULL — Foreign key → payment.pay_id — NOT NULL
  • bank_name — VARCHAR(100) — NOT NULL
  • bank_code — VARCHAR(20) — NOT NULL

pay_card

  • card_id — NOT NULL — Primary key — NOT NULL
  • pay_id — NOT NULL — Foreign key → payment.pay_id — NOT NULL
  • card_company — VARCHAR(100) — NOT NULL
  • payment_method — VARCHAR(255)

payment

  • pay_id — NOT NULL — Primary key — NOT NULL
  • method — VARCHAR(50) — NOT NULL

product

  • product_id — NOT NULL,UNIQUE — Primary key — NOT NULL
  • category_id — NOT NULL,UNIQUE — Foreign key → category.category_id — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • product_description — TEXT — NOT NULL
  • product_stock — INT — NOT NULL
  • regist_date — DATETIME
  • sell — ENUM('Y', 'N') — NOT NULL
  • product_category — VARCHAR(100)

shipment

  • ship_id — NOT NULL,UNIQUE — Primary key — NOT NULL
  • invoice_id — NOT NULL,UNIQUE — Foreign key → Invoice.invoice_id — NOT NULL
  • ship_name — VARCHAR(255)
  • ship_adderessee — VARCHAR(255)
  • ship_phone — VARCHAR(14)
  • zip_code — INT
  • address — VARCHAR(255)
  • ship_start — DATETIME
  • ship_end — DATETIME
  • ship_status — ENUM('M', 'F', 'O')