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