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