Fluffy ERD
Tables (8)
Comment (comment)
- Comment Id (comment_id) — INT — Primary key — NOT NULL
- Post Id (post_id) — INT — Foreign key → Post.Post Id — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Content (content) — TEXT
- Created At (created_at) — DATETIME
Inquiry (inquiry)
- Inquiry Id (inquiry_id) — INT — Primary key — NOT NULL
- Inquiry Question (inquiry_question) — VARCHAR(255)
- Inquiry Answer (inquiry_answer) — VARCHAR(255)
Post (post)
- Post Id (post_id) — INT — Primary key — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Content (content) — TEXT
- Created At (created_at) — DATETIME
Security Question (security_question)
- Question Id (question_id) — INT — Primary key — NOT NULL
- Question (question_text) — VARCHAR(255)
Time Range (time_range)
- Calendar Id (calendar_id) — INT — Primary key — NOT NULL
- Start Time (start_time) — DATETIME
- End Time (end_time) — DATETIME
TimeSlot (timeslot)
- TimeSlot Id (timeslot_id) — INT — Primary key — NOT NULL
- Day Of Week (day_of_week) — VARCHAR(10)
- Available Users (available_users) — JSON
- Calendar Id (calendar_id) — INT
- Start Time (start_time) — DATETIME
- End Time (end_time) — DATETIME
User (user)
- User Id (user_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
- Login Id (login_id) — VARCHAR(50)
- Password (password) — VARCHAR(100)
- Created At (created_at) — DATETIME
- Profile Image (profile_image_url) — VARCHAR(255)
User Security Answer (user_security_answer)
- Answer Id (answer_id) — INT — Primary key — NOT NULL
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Question Id (question_id_1) — INT — Foreign key → Security Question.Question Id — NOT NULL
- Question Id (question_id_2) — INT — Foreign key → Security Question.Question Id — NOT NULL
- Question Id (question_id_3) — INT — Foreign key → Security Question.Question Id — NOT NULL
- Answer 1 (answer_1) — VARCHAR(255)
- Answer 2 (answer_2) — VARCHAR(255)
- Answer 3 (answer_3) — VARCHAR(255)