dotoriv3-school

Tables (6)

Chat

  • chat_id — Long — Primary key — NOT NULL
  • content — string
  • school_id — Long — Foreign key → school.school_id — NOT NULL

club

  • club_id — Long — Primary key — NOT NULL
  • school_id — Long — Foreign key → school.school_id — NOT NULL
  • name — string
  • clubType — string
  • teacher_id — Long
  • representative_id — Long

school

  • school_id — Long — Primary key — NOT NULL
  • name — string
  • schoolType — Enum

school_detail

  • school_detail_id — Long — Primary key — NOT NULL
  • school_id — Long — Foreign key → school.school_id — NOT NULL
  • address — string
  • countOfStudent — Int
  • phoneNumber — string
  • email — string

school_room

  • school_room_id — Long — Primary key — NOT NULL
  • name — string
  • description — string
  • limit — Long

school_room_reservation

  • school_room_reservation_id — Long — Primary key — NOT NULL
  • school_room_id — Long — Foreign key → school_room.school_room_id — NOT NULL
  • student_id — Long
  • period — Date