dotoriv3-user

Tables (4)

Untitled (housemaster)

  • Key (housemaster_id) — Long — Primary key — NOT NULL
  • dormitory_id — Long
  • user_id — Long — Foreign key → user.Key — NOT NULL

student

  • Key (student_id) — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → user.Key — NOT NULL
  • school_id — Long
  • selfstudy_status — enum
  • massage_status — enum
  • school_room_reservation_status — enum

teacher

  • Key (teacher_id) — Long — Primary key — NOT NULL
  • school_id — Long
  • user_id — Long — Foreign key → user.Key — NOT NULL

user

  • Key (user_id) — Long — Primary key — NOT NULL
  • name — string
  • email — string
  • password — string