Gmarket_Seller Management System

Tables (5)

Notices

  • notice_id — int — Primary key — NOT NULL
  • title — nvarchar(200)
  • content — nvarchar(max)
  • created_at — datetime

Orders

  • order_id — int — Primary key — NOT NULL
  • product_id — int
  • status — nvarchar(20)
  • created_at — datetime
  • product_id (product_id2) — int — Foreign key → Products.product_id — NOT NULL

Products

  • product_id — int — Primary key — NOT NULL
  • seller_id — int
  • name — nvarchar(100)
  • description — nvarchar(500)
  • price — decimal(10,2)
  • created_at — datetime
  • seller_id (seller_id2) — int — Foreign key → Sellers.seller_id — NOT NULL

Sellers

  • seller_id — int — Primary key — NOT NULL
  • user_id — int
  • grade — nvarchar(20)
  • created_at — datetime
  • user_id (user_id2) — int — Foreign key → Users.user_id — NOT NULL

Users

  • user_id — int — Primary key — NOT NULL
  • username — nvarchar(50)
  • email — nvarchar(100)
  • password_hash — nvarchar(255)
  • role — nvarchar(20)
  • created_at — datetime