BookMall
Tables (10)
Cart (Untitled6)
- cart_id (Key3) — Primary key — NOT NULL
- member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
- product_id (Key2) — Foreign key → Product.id — NOT NULL
- pub_id (Key22) — Foreign key → Product.pub_id — NOT NULL
- categroy_id (Key32) — Foreign key → Product.categroy_id — NOT NULL
- cnt (Field)
Coupon (Untitled2)
- coupon_id (Key) — Primary key — NOT NULL
- name (Field2)
- exp (Field3)
Coupon_member (Untitled7)
- member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
- coupon_id (Key2) — Foreign key → Coupon.coupon_id — NOT NULL
- date (Field)
- used (Field2)
MEMBER
- member_id — VARCHAR(50) — Primary key — NOT NULL
- email (emai) — VARCHAR(100)
- pw — VARCHAR(100)
- name — VARCHAR(30)
- phone — char(20)
- gender — CHAR(10)
- birth — DATE
- date — DATE
- point — int
- login_platform — VARCHAR(30)
- addr — VARCHAR(100)
- adminCK — INT
Order (Untitled9)
- order_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key → Product.id — NOT NULL
- member_id (Key4) — Foreign key → MEMBER.member_id — NOT NULL
- cart_id (Key3) — Foreign key → Cart.cart_id — NOT NULL
- date (Field)
- cnt (Field2)
- price (Field3)
Payment (Untitled10)
- pay_num (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
- pay_method (Field2)
- total_price (Field3)
- monthly (Field)
Product (Untitled3)
- id (Key) — Primary key — NOT NULL
- pub_id (Key2) — Foreign key → Pub.pub_id — NOT NULL
- categroy_id (Key3) — Foreign key → category.categroy_id — NOT NULL
- name (Field)
- sell_cnt (Field2)
- date (Field4)
- price (Field6)
- like (Field7)
- desc (Field8)
- quantity (Field9)
Pub (Untitled4)
- pub_id (Key) — Primary key — NOT NULL
- pub_title (Field3)
- pub_dsc (Field)
Purchase_history (Untitled5)
- member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
- order_id (Key2) — Foreign key → Order.order_id — NOT NULL
- date (Field)
category (Untitled8)
- categroy_id (Key) — Primary key — NOT NULL
- name (Field)
- dsc (Field2)