cochalla

Tables (8)

Comment

  • Key — Primary key — NOT NULL
  • id — UUID
  • post_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • Key (Key3) — Foreign key → Post.Key — NOT NULL

GPTAnswer

  • Key — Foreign key → GPTQuestion.Key — NOT NULL
  • id — UUID
  • question_id — UUID — NOT NULL
  • answer_text — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

GPTQuestion

  • Key — Primary key — NOT NULL
  • id — UUID
  • user_id — UUID — NOT NULL
  • question_text — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL

Like

  • Key — Primary key — NOT NULL
  • id — UUID
  • user_id — UUID — NOT NULL
  • post_id — UUID — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • Key (Key3) — Foreign key → Post.Key — NOT NULL

Post

  • Key — Primary key — NOT NULL
  • id — UUID
  • user_id — UUID — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • Key (Key2) — Foreign key → User.Key — NOT NULL

ProfileImage

  • Key — Primary key — NOT NULL
  • id — UUID
  • image_url — VARCHAR(255) — NOT NULL
  • description — VARCHAR(100)

Summary

  • Key — Primary key — NOT NULL
  • id — UUID
  • post_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • created_by — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • Key (Key2) — Foreign key → Post.Key — NOT NULL

User

  • Key — Primary key — NOT NULL
  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_id — UUID
  • created_at — TIMESTAMP — NOT NULL
  • Key (Key2) — Foreign key → ProfileImage.Key — NOT NULL