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