Language
Tables (8)
allen
- allen_id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(10) — NOT NULL
- input_text — TEXT — NOT NULL
- summary — TEXT — NOT NULL
- created_date — TIMESTAMP — NOT NULL
chat_message
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_id — TEXT — NOT NULL
- message — VARCHAR(50) — NOT NULL
- sent_at — DATETIME — NOT NULL
contact
- contact_id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL — OPEN, IN PROGRESS, CLOSED
contact_file
- id (Key) — BIGINT — Primary key — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- contact_id — BIGINT — Foreign key → contact.contact_id — NOT NULL
review
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_date — DATETIME — NOT NULL
- updated_date — DATETIME — NOT NULL
review_file
- id (Key) — BIGINT — Primary key — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
til
- til_id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- summary — TEXT — NOT NULL
- created_date — TIMESTAMP — NOT NULL
- updated_date — TIMESTAMP — NOT NULL
users
- user_id (Key) — BIGINT — Primary key — NOT NULL
- provider — VARCHAR(20)
- email — VARCHAR(300) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- role — ENUM — NOT NULL — 0 = ROLE_ADMIN, 1 = ROLE_USER
- is_active — VARCHAR(1) — NOT NULL
- grade — INT — NOT NULL
- score — INT — NOT NULL
- created_date — TIMESTAMP — NOT NULL
- termination_date — DATE