검흰_마이그레이션

테이블 (14)

assignment_submissions

  • id — BIGINT
  • assignment_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT
  • file_url — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • score — INT
  • feedback — TEXT
  • submitted_at — TIMESTAMP

assignments

  • id — BIGINT
  • group_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • due_date — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP

boards

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

carts

  • id — BIGINT
  • user_id — BIGINT
  • session_id — VARCHAR(100)
  • lecture_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

comments

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

enrollments

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • lecture_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • progress — INT
  • enrolled_at — TIMESTAMP
  • completed_at — TIMESTAMP

group_members

  • id — BIGINT
  • group_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP

groups

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • teacher_id — BIGINT — NOT NULL
  • max_students — INT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

lecture_contents

  • id — BIGINT
  • lecture_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content_url — VARCHAR(255) — NOT NULL
  • order_num — INT — NOT NULL
  • duration — INT
  • created_at — TIMESTAMP

lectures

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • pro_player_name — VARCHAR(50) — NOT NULL
  • thumbnail_url — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payments

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • enrollment_id — BIGINT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • paid_at — TIMESTAMP
  • cancelled_at — TIMESTAMP
  • created_at — TIMESTAMP

posts

  • id — BIGINT
  • board_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

teacher_applications

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • description — TEXT
  • document_url — VARCHAR(255)
  • reviewed_by — BIGINT
  • reviewed_at — TIMESTAMP
  • created_at — TIMESTAMP

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP