ClubBlurBlur

Tables (15)

answer (Untitled7)

  • answer_id (Key) — NOT NULL — Primary key — NOT NULL
  • qua_id (Key2) — NOT NULL — Foreign key → qna.qna_id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • context (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL

club (Untitled4)

  • club_id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • member_cnt (Field2) — NOT NULL

club_calender (CopyOfCopyOfUntitled)

  • club_post_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE
  • url (Field4) — NULLABLE
  • Field5

club_post (CopyOfUntitled)

  • club_post_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE
  • url (Field4) — NULLABLE

letter (Untitled3)

  • letter_id (Key) — NOT NULL — Primary key — NOT NULL
  • personal_post_chat_id (Key2) — NOT NULL — Foreign key → personal_post_chat.personal_post_chat_id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL

manager (CopyOfUntitled42)

  • manager_id (Key) — NOT NULL — Primary key — NOT NULL
  • club_id (Key2) — NULLABLE — Foreign key → club.club_id — NOT NULL
  • id (Field) — NOT NULL
  • password (Field2) — NOT NULL

nested_reply (Untitled6)

  • nested_reply_id (Key) — NOT NULL — Primary key — NOT NULL
  • reply_id (Key2) — NOT NULL — Foreign key → reply.reply_id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NOT NULL
  • reply_like (Field5) — NOT NULL
  • is_anonymous (Field4) — NOT NULL

personal_post_chat (CopyOfUntitled3)

  • personal_post_chat_id (Key) — NOT NULL — Primary key — NOT NULL
  • post_id (Key2) — NOT NULL — Foreign key → post.post_id — NOT NULL

post (Untitled)

  • post_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE

post_image (CopyOfUntitled22)

  • post_image_id (Key) — NOT NULL — Primary key — NOT NULL
  • post_id (Key2) — NOT NULL — Foreign key → post.post_id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL

qna (CopyOfUntitled23)

  • qna_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • club_post_id (Key3) — NOT NULL — Foreign key → club_post.club_post_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE
  • is_Secret (Field4) — NOT NULL
  • has_Answer (Field5) — NOT NULL

reply (CopyOfUntitled2)

  • reply_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • post_id (Key2) — NOT NULL — Foreign key → post.post_id — NOT NULL
  • content (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE
  • reply_like (Field4) — NOT NULL
  • is_ anonymous (Field5) — NOT NULL

user (.)

  • user_id (Key) — NOT NULL — Primary key — NOT NULL
  • student_id (Field) — NOT NULL
  • password (Field2) — NOT NULL
  • type (Field3) — NOT NULL

user_club (Untitled5)

  • user_club_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • club_id (Key3) — NOT NULL — Foreign key → club.club_id — NOT NULL

vote (Untitled2)

  • vote_id (Key) — NOT NULL — Primary key — NOT NULL
  • post_id (Key2) — NOT NULL — Foreign key → post.post_id — NOT NULL
  • vote_title (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • modified_at (Field3) — NULLABLE