eidt_onlineshop
Tables (11)
books
- book_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- isbn — VARCHAR(20)
- title — VARCHAR(200) — NOT NULL
- author — VARCHAR(100)
- publisher — VARCHAR(100)
- publish_date — DATE
cart_items
- cart_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- added_at — DATETIME
categories
- category_id — BIGINT — NOT NULL
- parent_category_id — BIGINT
- category_name — VARCHAR(100) — NOT NULL
- display_order — INT
- is_active — BOOLEAN
- created_at — DATETIME
deliveries
- delivery_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- courier_name — VARCHAR(50)
- tracking_number — VARCHAR(50)
- delivery_status — VARCHAR(20)
- shipped_at — DATETIME
- delivered_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
order_items
- order_item_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
- discount_amount — INT
- subtotal — INT — NOT NULL
- item_status — VARCHAR(20)
orders
- order_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- order_number — VARCHAR(50) — NOT NULL
- total_amount — INT — NOT NULL
- discount_amount — INT
- shipping_fee — INT
- final_amount — INT — NOT NULL
- shipping_address — VARCHAR(255) — NOT NULL
- shipping_zipcode — VARCHAR(10)
- receiver_name — VARCHAR(100) — NOT NULL
- receiver_phone — VARCHAR(20) — NOT NULL
- delivery_memo — TEXT
- order_status — VARCHAR(20)
- order_date — DATETIME
payments
- payment_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- payment_method — VARCHAR(20) — NOT NULL
- payment_amount — INT — NOT NULL
- payment_status — VARCHAR(20)
- transaction_id — VARCHAR(100)
- payment_info — TEXT
- paid_at — DATETIME
- cancelled_at — DATETIME
- created_at — DATETIME
product_reviews
- review_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- order_item_id — BIGINT
- rating — INT — NOT NULL
- title — VARCHAR(200)
- content — TEXT
- image_urls — TEXT
- created_at — DATETIME
- updated_at — DATETIME
products
- product_id — BIGINT — NOT NULL
- category_id — BIGINT
- product_name — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- discount_rate — INT
- stock_quantity — INT
- description — TEXT
- image_url — VARCHAR(500)
- rating — DECIMAL(2,1)
- sales_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- is_active — BOOLEAN
user_roles
- role_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role_name — VARCHAR(20)
- granted_at — DATETIME
users
- user_id — BIGINT — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(255)
- zipcode — VARCHAR(10)
- birth_date — DATE
- gender — VARCHAR(10)
- user_grade — VARCHAR(20)
- user_status — VARCHAR(20)
- last_login_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- is_active — BOOLEAN