msa

Tables (4)

courses

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50) — NOT NULL — FOOD|DRINK|DAILY|FRESH|SNACK|HYGIENE|CHILLED|OTHER
  • price — DECIMAL(10, 2) — NOT NULL
  • instructor_id — BIGINT — Foreign key → users.id — NOT NULL
  • enrollment_count — INT — NOT NULL — 재고 수량(전역)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

enrollments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • quantity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED|APPROVED|REJECTED|RECEIVED
  • reject_reason — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.id — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING|COMPLETED|FAILED|CANCELLED
  • transaction_id — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(30) — NOT NULL — STUDENT(가맹점) | INSTRUCTOR(본사)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)