20250606_Admin_Gmarket
Tables (6)
GradeHistory
- history_id — INT, PK — Primary key — NOT NULL
- seller_id — INT, FK
- changed_at — DATETIME
- from_grade — VARCHAR
- to_grade — VARCHAR
- reason — TEXT
- changed_by — VARCHAR
- seller_id (seller_id2) — INT, PK — Foreign key → Seller.seller_id — NOT NULL
GradeScore
- score_id — INT, PK — Primary key — NOT NULL
- seller_id — INT, FK
- period_start — DATE
- period_end — DATE
- sales_amount — INT
- sales_count — INT
- fast_delivery — INT
- deadline — INT
- response — INT
- satisfaction — INT
ManualGradeChange
- manual_id — INT, PK — Primary key — NOT NULL
- seller_id — INT, FK
- requested_at — DATETIME
- target_grade — VARCHAR
- reason — TEXT
- processed_by — VARCHAR
- processed_at — DATETIME
- Field
- user_id — INT, PK — Foreign key → User.user_id — NOT NULL
Notice
- notice_id — INT, PK — Primary key — NOT NULL
- title — VARCHAR
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- created_by — INT, FK
- is_active — BOOLEAN
- user_id — INT, PK — Foreign key → User.user_id — NOT NULL
Seller
- seller_id — INT, PK — Primary key — NOT NULL
- username — VARCHAR
- name — VARCHAR
- current_grade — VARCHAR
- created_at — DATETIME
- user_id — INT, PK — Foreign key → User.user_id — NOT NULL
- score_id — INT, PK — Foreign key → GradeScore.score_id — NOT NULL
User
- user_id — INT, PK — Primary key — NOT NULL
- username — VARCHAR
- password_hash — VARCHAR
- email — VARCHAR
- name — VARCHAR
- created_at — DATETIME