SW-Academic-Festival
Tables (7)
AcademicCalendar
- academicSchedule_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- description — varchar(150)
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- member_id — bigint — NOT NULL
Club
- club_idx — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(50)
- description — varchar(150)
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- member_id — bigint — NOT NULL
College
- college_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(50)
- description — varchar(150)
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- member_id — bigint — NOT NULL
Competition
- competition_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(50)
- description — varchar(150)
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- member_id — bigint — NOT NULL
Dodream
- dodream_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(50)
- description — varchar(150)
- startDate — datetime — NOT NULL
- endDate — datetime — NOT NULL
- member_id — bigint — NOT NULL
User
- member_id — bigint — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(200) — NOT NULL
- department — varchar(25)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL