thestorks
Tables (14)
apikey (security_apikey)
- id — char(32) — Primary key — NOT NULL
- created — datetime — NOT NULL
- modified — datetime — NOT NULL
- name — varchar(50) — NOT NULL
- key — varchar(40) — NOT NULL
chatmessage (chat_chatmessage)
- id — integer — Primary key — NOT NULL
- product (product_id) — integer — Foreign key → product.id — NOT NULL
- person (person_id) — integer — Foreign key → person.id — NOT NULL
- kind — varchar(10) — NOT NULL
- message — varchar(200) — NOT NULL
- create_time — datetime — NOT NULL
context (dialog_context)
- context — varchar(100) — Primary key — NOT NULL
- intent_list — varchar(1000)
dialog_entity_entity_items
- id — integer — Primary key — NOT NULL
- entity_id — varchar(50) — Foreign key → entity.entity — NOT NULL
- entityitem_id — varchar(50) — Foreign key → entityitem.object_name — NOT NULL
dialog_intent_entity
- id — integer — Primary key — NOT NULL
- entity_id — varchar(50) — Foreign key → entity.entity — NOT NULL
- intent_id — varchar(100) — Foreign key → intent.intent_name — NOT NULL
entity (dialog_entity)
- entity — varchar(50) — Primary key — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
entityitem (dialog_entityitem)
- object_name — varchar(50) — Primary key — NOT NULL
- properties — varchar(1000) — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
family (user_family)
- id — integer — Primary key — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
intent (dialog_intent)
- intent_name — varchar(100) — Primary key — NOT NULL
- training_phrase — varchar(5000) — NOT NULL
- response — varchar(5000) — NOT NULL
- input_context — varchar(500) — NOT NULL
- output_context — varchar(500) — NOT NULL
- priority — integer
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
person (user_person)
- id — integer — Primary key — NOT NULL
- family (family_id) — integer — Foreign key → family.id — NOT NULL
- profile (profile_id) — integer — Foreign key → profile.id — NOT NULL
- kind — varchar(2) — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
postposition (dialog_postposition)
- id — integer — Primary key — NOT NULL
- variation — integer — NOT NULL
- form1 — varchar(10) — NOT NULL
- form2 — varchar(10) — NOT NULL
product (user_product)
- id — integer — Primary key — NOT NULL
- family (family_id) — integer — Foreign key → family.id — NOT NULL
- profile (profile_id) — integer — Foreign key → profile.id — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
profile (user_profile)
- id — integer — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- birthdate — varchar(8) — NOT NULL
- gender — varchar(10) — NOT NULL
- create_id — varchar(20) — NOT NULL
- create_time — datetime — NOT NULL
- modify_id — varchar(20) — NOT NULL
- modify_time — datetime — NOT NULL
resource (play_resource)
- id — integer — Primary key — NOT NULL
- dir_path — varchar(200) — NOT NULL
- file_name — varchar(100) — NOT NULL
- author — varchar(200) — NOT NULL
- title — varchar(200) — NOT NULL
- kind — varchar(2) — NOT NULL