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