SJ_Chat

Tables (17)

Entity

  • entity_id — integer
  • name — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

Entity_Value

  • entity_value_id — integer
  • entity_id — integer — Foreign key → Entity.entity_id
  • value — varchar(255)
  • created_at — DATETIME
  • updated_at — DATETIME

Intent

  • intent_id — integer
  • name — varchar(255)
  • response — text
  • created_at — DATETIME
  • updated_at — DATETIME

Intent_Entity

  • intent_id — integer — Foreign key → Intent.intent_id
  • entity_id — integer — Foreign key → Entity.entity_id

User_Input

  • user_input_id — integer
  • user_id — integer — Foreign key → user.username
  • input_text — text
  • created_at — DATETIME
  • updated_at — DATETIME

User_Input_Entity

  • user_input_id — integer — Foreign key → User_Input.user_input_id
  • entity_id — integer — Foreign key → Entity.entity_id
  • entity_value_id — integer — Foreign key → Entity_Value.entity_value_id

calendar

  • date — date
  • schedule_id — integer — Foreign key → schedule.schedule_id
  • event_id — integer — Foreign key → event.event_id

chat

  • chat_id — integer
  • name — varchar(255)
  • created_at — DATETIME
  • updated_at — DATETIME

chat_user

  • chat_id — integer — Foreign key → chat.chat_id
  • user_id — integer — Foreign key → user.user_id
  • owner — boolean

course

  • course_id — integer
  • name — varchar(255)
  • department_id — integer — Foreign key → department.department_id
  • location — varchar(255) — Foreign key → location.location

department

  • department_id — integer
  • name — varchar(255)

enroll

  • enroll_id — integer
  • user_id — integer — Foreign key → user.user_id
  • course_id — integer — Foreign key → course.course_id

event

  • event_id — integer
  • user_id — integer — Foreign key → user.user_id
  • title — varchar(255)
  • description — text
  • start — INTERVAL_DAY
  • end — INTERVAL_DAY
  • location — varchar(255)

location

  • location — varchar(255)

message

  • message_id — integer
  • chat_id — integer — Foreign key → chat.chat_id
  • user_id — integer — Foreign key → user.user_id
  • content — text
  • created_at — DATETIME
  • updated_at — DATETIME

schedule

  • schedule_id — integer
  • course_id — integer — Foreign key → course.course_id
  • start — INTERVAL_DAY
  • end — INTERVAL_DAY
  • location — varchar(255) — Foreign key → location.location

user

  • user_id — integer — NOT NULL
  • username — varchar(255)
  • role — integer
  • department1_id — integer — Foreign key → department.department_id — NOT NULL
  • department2_id — integer — Foreign key → department.department_id
  • Email — varchar(255)
  • password — varchar(255)