sp
Tables (8)
admin
- admin_id — bigint — Primary key — NOT NULL
- password — varchar(200)
- authorization — varchar(200)
- is_use — tinyint(1) — NOT NULL
certification
- social_id — varchar(255) — NOT NULL
- email — varchar(255)
- certification_number — varchar(255)
feedback
- id — varchar(255) — Primary key — NOT NULL
- report_id — bigint — NOT NULL
- is_use — tinyint(1) — NOT NULL
record
- record_id — bigint — Primary key — NOT NULL
- script_id — bigint — NOT NULL
- audio_path — longtext
- language_code — varchar(60)
- created_at — datetime
- is_use — tinyint(1) — NOT NULL
report
- report_id — bigint — Primary key — NOT NULL
- speech_id — bigint — NOT NULL
- recognized — varchar(200)
- score — double
- content — varchar(200)
- created_at — datetime
- is_public — tinyint(1)
- is_use — tinyint(1) — NOT NULL
script
- script_id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- content — varchar(300)
- created_at — datetime
- modified_at — datetime
- is_use — tinyint(1) — NOT NULL
template
- template_id — varchar(60) — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- template — varchar(255)
- is_use — tinyint(1) — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- social_id — varchar(60)
- email — varchar(60)
- name — varchar(60)
- level — varchar(60)
- authorization — varchar(60)
- is_use — tinyint(1) — NOT NULL