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)
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)