ㅁㄴㅇㅁ

Tables (5)

Customers

  • customer_id — INT — Primary key — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • phone — CHAR(11) — NOT NULL
  • gender — ENUM('M', 'F', 'O') — NOT NULL
  • join_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

Grade_Tiers

  • tier_id — INT — Primary key — NOT NULL
  • grade_name — VARCHAR(10) — NOT NULL
  • min_amount — DECIMAL(10, 2) — NOT NULL
  • max_amount — DECIMAL(10, 2)
  • benefit — VARCHAR(255)

Grades

  • customer_id — INT — Foreign key → Customers.customer_id — NOT NULL
  • sum_account — DECIMAL(10, 2) — NOT NULL
  • grade_name — VARCHAR(10) — Foreign key → Grade_Tiers.grade_name — NOT NULL
  • update_date — DATETIME — NOT NULL
  • last_calculated_at — TIMESTAMP — NOT NULL

Logs

  • log_id — INT — Primary key — NOT NULL
  • customer_id — INT — Foreign key → Customers.customer_id — NOT NULL
  • store_id — INT — Foreign key → Stores.store_id — NOT NULL
  • purchase_date — DATETIME — NOT NULL
  • account — DECIMAL(10, 2) — NOT NULL

Stores

  • store_id — INT — Primary key — NOT NULL
  • store_name — VARCHAR(50) — NOT NULL
  • location — VARCHAR(100)