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