test
Tables (9)
Customer (Untitled)
- customerID (customer_id) — NOT NULL — Primary key — NOT NULL
- user_name — NOT NULL
- user_phone — NOT NULL
- user_grade — NOT NULL
- user_accomulated — NOT NULL
Easy_join (easy_join)
- user_email_id (email_id) — NOT NULL — Primary key — NOT NULL
- user_number (Key) — NOT NULL — Primary key — NOT NULL
- user_easy_number (easy_number) — NOT NULL
- Field2
Mart (마트)
- martID (mart_id2) — NOT NULL — Foreign key → Order.martID — NOT NULL
- martName (mart_name) — NOT NULL
- martAddress (mart_address) — NOT NULL
- martTel (mart_tel) — NOT NULL
Order (주문)
- orderID (order_id) — NOT NULL — Primary key — NOT NULL
- martID (mart_id) — NOT NULL — Primary key — NOT NULL
- orderTime (order_time) — NOT NULL
- orderAmount (order_amount) — NOT NULL
- orderQauntity (order_qauntity) — NOT NULL
- orderPayment (order_payment) — NOT NULL
OrderDetail (주문상세)
- Key — Primary key — NOT NULL
- orderID (order_id) — NOT NULL — Foreign key → Order.orderID — NOT NULL
- martID (mart_id) — NOT NULL — Foreign key → Order.martID — NOT NULL
- productID (product_id) — NOT NULL — Foreign key → Product.productID — NOT NULL
- customerID (customer_id) — NOT NULL — Foreign key → Customer.customerID — NOT NULL
- productAmount (product_amount) — NOT NULL
Product (상품)
- productID (product_id) — NOT NULL — Primary key — NOT NULL
- productName (product_name) — NOT NULL
- productCategory (product_category) — NOT NULL
- productPrice (product_price) — NOT NULL
- productTax (product_tax) — NOT NULL
- Field
ex1 (Untitled2)
- Key — Primary key — NOT NULL
ex1 (Untitled3)
- Key — Primary key — NOT NULL
join
- user_number (userNumber) — NOT NULL — Primary key — NOT NULL
- user_id (userID) — NOT NULL
- user_password (password) — NOT NULL
- user_name (name) — NOT NULL
- user_phone (phone) — NOT NULL
- user_email (email) — NOT NULL
- user_grade (grade) — NOT NULL
- user_address (address) — NOT NULL
- join_date (creatDate) — NOT NULL
- user_accumulated (accumulated) — NOT NULL