shoppingmall
Tables (10)
Address
- addrKey — INT — Primary key — NOT NULL
- customerKey — INT — Foreign key → customer.customer_number — NOT NULL
- customer_name — VARCHAR(15) — NOT NULL
- postal_code — VARCHAR(300) — NOT NULL
- address_customer — VARCHAR(300) — NOT NULL
- address_detail — VARCHAR(100) — NOT NULL
- tel_customer — VARCHAR(15) — NOT NULL
- request_order — VARCHAR(100)
- DEFAULT_addr — VARCHAR(1)
admin
- admin_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(150) — NOT NULL
board
- boardKey — INT — Primary key — NOT NULL
- customer_number — INT — Foreign key → customer.customer_number — NOT NULL
- itemKey — INT — Foreign key → item.itemKey — NOT NULL
- ntype — VARCHAR(1) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- rdate — DATETIME
- content — VARCHAR(300) — NOT NULL
- img — VARCHAR(600)
- rate — INT
cart
- cartKey — INT — NOT NULL
- customer_key — INT — NOT NULL
- itemKey — INT — NOT NULL
- cnt — INT
- rdate — DATE
category
- category_id — INT
- name — VARCHAR(100) — NOT NULL
customer
- email — VARCHAR(50) — Primary key — NOT NULL
- customer_number — bigINT
- username — VARCHAR(15) — NOT NULL
- userpwd — VARCHAR(150) — NOT NULL
- telnum — VARCHAR(15) — NOT NULL
- n_id_num — INT
- gender — INT
- banned — VARCHAR(1)
- signout — VARCHAR(1)
item
- itemKey — INT — Primary key — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- img1 — VARCHAR(600) — NOT NULL
- img2 — VARCHAR(600)
- img3 — VARCHAR(600)
- img4 — VARCHAR(600)
- img5 — VARCHAR(600)
- content — VARCHAR(1000)
- price — INT — NOT NULL
- saleprice — INT — NOT NULL
- regdate — DATE
- cnt — INT — NOT NULL
- delected — VARCHAR(1)
orderDetail
- ORDERDetKey — INT — NOT NULL
- ORDERKey — INT — Foreign key → shoppingmall.id — NOT NULL
- itemKey — INT — Foreign key → item.itemKey — NOT NULL
- price — INT
- cnt — INT
product
- product_id — INT
- name — VARCHAR(150) — NOT NULL
- image — VARCHAR(600) — NOT NULL
- price — INT — NOT NULL
- category_id — INT — Foreign key → category.category_id
shoppingmall
- id — bigINT
- customer_number — INT — Foreign key → customer.customer_number — NOT NULL
- total_payment — INT — NOT NULL
- order_date — DATEtime
- card_company — VARCHAR(20)
- order_status — VARCHAR(20)
- refund_reason — VARCHAR(300)
- customer_name — VARCHAR(15) — NOT NULL
- postal_code — VARCHAR(6) — NOT NULL
- address_customer — VARCHAR(300) — NOT NULL
- address_detail — VARCHAR(100) — NOT NULL
- tel_customer — VARCHAR(15) — NOT NULL
- request_order — VARCHAR(100)
- item_pc — INT — NOT NULL
- main_item — VARCHAR(150)
- main_item_img — VARCHAR(600)