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 가져오는 값