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