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