Gasip
Tables (8)
board
- post_id — bigint — Primary key — NOT NULL
- reg_date — datetime(6)
- update_date — datetime(6)
- click_count — bigint — NOT NULL
- content — varchar(500) — NOT NULL
- grade_point — int — NOT NULL
- like_count — bigint — NOT NULL
- member_id — bigint — Foreign key → member.member_id
- prof_id — bigint — Foreign key → prof.prof_id
category
- id — bigint — Primary key — NOT NULL
- college_name — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- parent_category_id — bigint — Foreign key → category.id
- major_name — varchar(255) — NOT NULL
comment
- comment_id — bigint — Primary key — NOT NULL
- reg_date — datetime(6)
- update_date — datetime(6)
- comment_like — bigint
- content — varchar(255) — NOT NULL
- post_id — bigint — Foreign key → board.post_id
- member_id — bigint — Foreign key → member.member_id
- parent_id — bigint — Foreign key → comment.comment_id
comment_likes
- commentlikes_id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → board.post_id
- comment_id — bigint — Foreign key → comment.comment_id
- member_id — bigint — Foreign key → member.member_id
grade
- grade_id — bigint — Primary key — NOT NULL
- reg_date — datetime(6)
- update_date — datetime(6)
- gradepoint — int — NOT NULL
- member_id — bigint — Foreign key → member.member_id
- prof_id — bigint — Foreign key → prof.prof_id
likes
- likes_id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → board.post_id
- member_id — bigint — Foreign key → member.member_id
member
- member_id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum('ADMIN','MEMBER')
- nickname — varchar(255) — NOT NULL
prof
- prof_id — bigint — Primary key — NOT NULL
- prof_name — varchar(40) — NOT NULL
- major_id — bigint — Foreign key → category.id