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