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

CreativeSemester

    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