test

Tables (11)

Admin

  • admin_id — BIGINT
  • employee_id — BIGINT — NOT NULL
  • password — VARCHAR(255) — NOT NULL

Auction_Products

  • product_id — BIGINT
  • auction_start_time — DATETIME — NOT NULL
  • auction_end_time — DATETIME — NOT NULL
  • starting_bid — DECIMAL(10, 2) — NOT NULL
  • final_bid — DECIMAL(10, 2)

Category

  • category_id — INT
  • category_name — VARCHAR(255) — NOT NULL

General_Products

  • product_id — BIGINT
  • quantity — INT — NOT NULL
  • saved_count — INT

Order

  • order_id — BIGINT
  • status — BOOLEAN — NOT NULL
  • user_id — BIGINT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • purchase_type — BOOLEAN
  • product_id — BIGINT — NOT NULL

Product

  • product_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • brand — VARCHAR(255)
  • price — DECIMAL(10, 2) — NOT NULL
  • category_id — INT — NOT NULL
  • auction_type — BOOLEAN

Sale

  • sale_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • sale_status — ENUM('Pending', 'Completed', 'Cancelled') — NOT NULL

Sale_Products

  • sp_id — BIGINT
  • sale_id — BIGINT — NOT NULL
  • sale_price — DECIMAL(10, 2) — NOT NULL
  • first_status — INT
  • product_name — VARCHAR(255)
  • auction_type — BOOLEAN
  • brand — VARCHAR(255)
  • category — VARCHAR(255)

User_Coupons

  • coupon_id — BIGINT
  • discount_rate — DECIMAL(5, 2) — NOT NULL
  • coupon_registration_date — DATE — NOT NULL
  • coupon_expiration_date — DATE — NOT NULL
  • user_id — BIGINT — NOT NULL

User_Saved

  • saved_id — BIGINT
  • product_id — BIGINT — NOT NULL
  • style_feed_id — INT
  • user_id — BIGINT — NOT NULL

Users

  • user_id — BIGINT
  • login_id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • seller_grade — VARCHAR(50)