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')