ss

Tables (8)

class

  • id — BIGINT
  • instructor_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • game_type — VARCHAR(100)
  • price — INT — NOT NULL

instructor

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • career — TEXT
  • review_num — INT
  • rating — FLOAT

payment

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • payment_type — ENUM('CARD', 'BANK', 'KAKAO', 'FREE') — NOT NULL
  • status — ENUM('READY', 'SUCCESS', 'FAILED', 'REFUNDED')
  • paid_at — DATETIME
  • transaction_id — VARCHAR(255)

replay

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • meta_data — TEXT
  • summary — TEXT
  • uploaded_at — DATETIME

reservation

  • id — BIGINT
  • student_id — BIGINT — NOT NULL
  • class_id — BIGINT — NOT NULL
  • reserved_at — DATETIME — NOT NULL
  • status — ENUM('PENDING', 'PAID', 'CONFIRMED', 'CANCELLED')
  • replay_id — BIGINT
  • review_id — BIGINT
  • payment_id — BIGINT

review

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • created_at — DATETIME

student

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • level — VARCHAR(50)

user

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)
  • profile_image — VARCHAR(255)
  • phone — VARCHAR(30)
  • role — ENUM('INSTRUCTOR', 'STUDENT') — NOT NULL