Kylemall
Tables (10)
chat_message
- message_id — BIGINT
- room_id — VARCHAR(50) — NOT NULL
- sender — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- message — TEXT — NOT NULL
- message_type — VARCHAR(10) — NOT NULL
- sent_at — TIMESTAMP
chat_room
- room_id — VARCHAR(50)
- room_name — VARCHAR(100) — NOT NULL
- created_by — VARCHAR(50) — NOT NULL
- room_admin — VARCHAR(50) — NOT NULL
- room_password — VARCHAR(100)
- max_users — INT
- current_users — INT
- created_at — TIMESTAMP
chat_room_participant
- room_id — VARCHAR(50)
- member_id — VARCHAR(50)
- joined_at — TIMESTAMP
faq
- faq_no — INTEGER
- faq_title — VARCHAR(50) — NOT NULL
- faq_content — VARCHAR(10000) — NOT NULL
- faq_reg_date — TIMESTAMP — NOT NULL
orderdetail
- detail_id — INTEGER
- detail_quantity — INTEGER — NOT NULL
- merchant_uid — VARCHAR(50) — NOT NULL
- product_no — INTEGER — NOT NULL
orders
- merchant_uid — VARCHAR(50)
- member_id — VARCHAR(50) — NOT NULL
- total_amount — INTEGER — NOT NULL
- order_status — VARCHAR(10)
- product_title — VARCHAR(50) — NOT NULL
- order_msg — VARCHAR(300)
- order_created_at — TIMESTAMP
- order_updated_at — TIMESTAMP
payment
- imp_uid — VARCHAR(50)
- merchant_uid — VARCHAR(50) — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- payment_status — ENUM('PENDING', 'PAID', 'CANCELLED', 'FAILED')
- amount — INTEGER — NOT NULL
- paid_at — TIMESTAMP
- cancelled_at — TIMESTAMP
- payment_created_at — TIMESTAMP
- payment_updated_at — TIMESTAMP
product
- product_no — INTEGER
- product_name — VARCHAR(50) — NOT NULL
- product_description — TEXT — NOT NULL
- product_price — INTEGER — NOT NULL
- stock_quantity — INTEGER — NOT NULL
- image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- category_no — INTEGER — NOT NULL
- sale_ok — TINYINT(1) — NOT NULL
- sale_price — INTEGER
shipping
- shipping_id — INTEGER
- merchant_uid — VARCHAR(50) — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(15) — NOT NULL
- delivery_status — ENUM('배송 준비 중', '배송 중', '배송 완료', '배송 취소')
- tracking_number — VARCHAR(50)
- shipping_date — DATETIME
- estimated_arrival — DATETIME
- shipping_msg — VARCHAR(300)
- shipping_created_at — TIMESTAMP
- shipping_updated_at — TIMESTAMP
shoppingcart
- cart_id — INTEGER
- quantity — INTEGER — NOT NULL
- added_at — TIMESTAMP
- member_id — VARCHAR(50) — NOT NULL
- product_no — INTEGER — NOT NULL