Queristia

Tables (3)

Question (Untitled2)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • 유저아이디 (userId) — BIGINT — Foreign key → User.ID — NOT NULL
  • 질문제목 (title) — VARCHAR
  • 질문내용 (content) — VARCHAR
  • 카테고리 (category) — VARCHAR
  • 상태 (status) — VARCHAR
  • 생성날짜 (createdAt) — VARCHAR

User (Untitled)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • 유저이메일 (userEmail) — VARCHAR
  • 패스워드 (password) — VARCHAR
  • 닉네임 (nickname) — VARCHAR
  • 등급 (rank) — VARCHAR
  • 인기도 (Popularity) — BIGINT
  • 생성날짜 (createAt) — TIMESTAMP

answers (Untitled3)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • 질문아이디 (questionId) — BIGINT — Foreign key → Question.ID — NOT NULL
  • 유저아이디 (userId) — BIGINT — Foreign key → User.ID — NOT NULL
  • 질문내용 (content) — VARCHAR
  • 생성날짜 (createdAt) — TIMESTAMP