(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