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)