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