ㅁ
Tables (6)
Answers
- id — SERIAL
- question_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Calendars
- id — SERIAL
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- UNIQUE(user_id, — date)
Logs
- id — SERIAL
- user_id — INT
- action — VARCHAR(50) — NOT NULL
- target_id — INT — NOT NULL
- target_type — ENUM('Question', 'Answer') — NOT NULL
- timestamp — TIMESTAMP
Questions
- id — SERIAL
- calendar_id — INT — NOT NULL
- user_id — INT
- nickname — VARCHAR(50)
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Shares
- id — SERIAL
- question_id — INT
- answer_id — INT
- platform — VARCHAR(50) — NOT NULL
- shared_by — INT — NOT NULL
- shared_at — TIMESTAMP
Users
- id — SERIAL
- username — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(255)
- profile_picture — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP