AYU-CSE Community

Tables (7)

Comment

  • comment_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • post_id — bigint — Foreign key → Post.post_id — NOT NULL
  • user_id (user_id2) — bigint — Foreign key → Post.user_id — NOT NULL
  • content — text
  • date — date — NOT NULL
  • parent_id — bigint — Foreign key → Comment.comment_id — NOT NULL

LIke (Like)

  • like_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • post_id — bigint — Foreign key → Post.post_id — NOT NULL

Post (OpenBoard)

  • post_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • category — varchar(50) — NOT NULL
  • title — varchar(50)
  • content — text
  • date — date — NOT NULL
  • views — bigint

Post (ResourceBoard)

  • post_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • title — varchar(50)
  • content — text
  • date — date — NOT NULL
  • views — bigint

Save (OpenSave)

  • save_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • post_id — bigint — Foreign key → Post.post_id — NOT NULL

Save (ResourceSave)

  • save_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • post_id — bigint — Foreign key → Post.post_id — NOT NULL

User

  • user_id — bigint — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL