devfest

Tables (6)

User (유저)

  • id — Long — Primary key — NOT NULL
  • name — String
  • email — String
  • stuNum — String
  • userrole — enum
  • conference_member_id — Long — Foreign key → conference_member.id — NOT NULL
  • lecture_member_id — Long — Foreign key → lecture_member.id — NOT NULL

conference (컨퍼런스)

  • id — Long — Primary key — NOT NULL
  • Presenter_id (presenter_id) — Long — Foreign key → User.id — NOT NULL
  • title — string
  • content — string
  • conference_date — localdatetime
  • start_register_date (startdate) — date
  • end_register_date (enddate) — date

conference_member (참가자)

  • id — Long — Primary key — NOT NULL
  • conference_id — Long — Foreign key → conference.id — NOT NULL

conference_request (발표자신청)

  • id — Long — Primary key — NOT NULL
  • title — string
  • content — string
  • user_id — Long — Foreign key → User.id — NOT NULL

lecture (강의)

  • id — Primary key — NOT NULL
  • title
  • content
  • presenter_name
  • conference_date
  • section
  • start_register_date (startdate)
  • end_register_date (registerdate)

lecture_member (CopyOf참가자)

  • id — Long — Primary key — NOT NULL
  • lecture_id — Foreign key → lecture.id — NOT NULL