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)