(Admin) Gmarket_Seller Management System

Tables (4)

Admin

  • user_id — INT — Primary key — NOT NULL
  • password_hash — NVARCHAR(255)
  • created_at — DATETIME

Grades

  • grade_id — INT — Primary key — NOT NULL
  • grade_name — NVARCHAR(100)
  • sales_amount — NVARCHAR(50)
  • fast_delivery_rate — TEXT
  • order_fulfillment_rate — FLOAT
  • customer_score — FLOAT
  • created_at — DATETIME
  • seller_id — INT — Foreign key → Sellers.seller_id — NOT NULL

Notices

  • notice_id — INT — Primary key — NOT NULL
  • title — NVARCHAR(200)
  • content — TEXT
  • target_group — NVARCHAR(20)
  • created_at — DATETIME
  • user_id — INT — Foreign key → Admin.user_id — NOT NULL

Sellers

  • seller_id — INT — Primary key — NOT NULL
  • grade — NVARCHAR(20)
  • sales_amount — DECIMAL(15,2)
  • fast_delivery_rate — FLOAT
  • order_fulfillment_rate — FLOAT
  • customer_score — FLOAT
  • created_at — DATETIME