김희옥(20239383)
테이블 (7)
Comments
- comment_id — INT
- post_id — INT
- member_id — INT
- content — TEXT
- created_at — TIMESTAMP
Members
- member_id — INT
- name — NCHAR(100)
- phone — CHAR(20)
- email — NCHAR(100)
- address — NCHAR(100)
OrderDetails
- order_detail_id — INT
- order_id — INT
- product_id — INT
- quantity — INT
Orders
- order_id — INT
- order_date — DATETIME
- shipping_address — NCHAR(100)
Products
- product_id — INT
- product_name — NCHAR(200)
- stock_quantity — CHAR(200)
- unit_price — CHAR(200)
ShippingAddresses
- shipping_id — INT
- order_id — INT
- shipping_address — NCHAR(100)
Suppliers
- supplier_id — INT
- supplier_name — NCHAR(200)
- phone — CHAR(20)
- contact_person — NCHAR(100)
- address — NCHAR(100)