GDSC-WEB-BackEnd

Tables (9)

TB_category (Untitled2)

  • catergoryId (Key) — Primary key — NOT NULL — autoIncreament
  • categoryName (Field) — 카테고리 이름 !

TB_likes (likes)

  • userid — VARCHAR(64) — Foreign key → TB_member.userid — NOT NULL — oauth 2.0 가져오는 값
  • postId (post_id2) — BIGINT — Foreign key → TB_post.postId — NOT NULL

TB_member (member)

  • userid — VARCHAR(64) — Primary key — NOT NULL — oauth 2.0 가져오는 값
  • username — VARCHAR(255) — NOT NULL — 실명
  • password — VARCHAR(255) — NOT NULL — 비번 / 자동
  • email — VARCHAR(255) — 이메일
  • email_verified_yn — VARCHAR(1) — 이메일 인증
  • role — VARCHAR(255) — 멤버 접근 권한
  • provider_type — VARCHAR(255) — 구글 / 카카오 / 네이버
  • modified_at — datetime — 수정날짜
  • upload_date — datetime — 업데이트날짜

TB_member_info (member_info)

  • userid — VARCHAR(64) — Foreign key → TB_member.userid — NOT NULL — oauth 2.0 가져오는 값
  • introduce (Field) — NOT NULL — 소개글
  • nick_name (Field2) — VARCHAR(64) — NOT NULL — GDSC 영어이름
  • phone_number — varchar(30) — NOT NULL — 전화번호
  • git_email — NOT NULL — 깃허브 이메일 / 닉네임
  • studentid (Field3) — varchar(16) — NOT NULL — 대진대 학번
  • major — varchar(30) — NOT NULL — 전공
  • position_type (positioType) — VARCHAR(50) — NOT NULL — Backend,Design, Frontend
  • catergoryId (Key) — Foreign key → TB_category.catergoryId — NOT NULL — autoIncreament

TB_member_scrap_post (member_scrap_post)

  • userid — VARCHAR(64) — Foreign key → TB_member.userid — NOT NULL — oauth 2.0 가져오는 값
  • postId (post_id2) — BIGINT — Foreign key → TB_post.postId — NOT NULL

TB_post (post)

  • postId (post_id) — BIGINT — Primary key — NOT NULL
  • image_path — VARCHAR(255) — 포스트이미지
  • title — VARCHAR(255) — 포스트제목
  • user_id — BIGINT
  • tmp_store — BIT(1)
  • catergoryId (Key) — Foreign key → TB_category.catergoryId — NOT NULL — autoIncreament
  • modified_at — datetime — 수정날짜
  • upload_date — datetime — 업로드 날짜
  • content — LONGTEXT

TB_post_hash_tag (post_hash_tag)

  • post_hash_id (id) — INT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • create_date — datetime
  • postId (post_id2) — BIGINT — Foreign key → TB_post.postId — NOT NULL

TB_user_refresh_token (user_refresh_token)

  • userid — VARCHAR(64) — Foreign key → TB_member.userid — NOT NULL — oauth 2.0 가져오는 값
  • refresh_token — VARCHAR(256) — RefreshToken (JWT 토큰)

TB_warn_description (warn_description)

  • warn_description_id — BIGINT — Primary key — NOT NULL — 경고PK
  • title — VARCHAR(255) — 경고타이틀
  • content — LONGTEXT — 경고내용
  • upload_date — datetime
  • userid (userid2) — VARCHAR(64) — Foreign key — NOT NULL — oauth 2.0 가져오는 값
  • userid — VARCHAR(64) — Foreign key → TB_member_info.userid — NOT NULL — oauth 2.0 가져오는 값