AIhomepage
Tables (10)
History (연혁)
- history_id (id) — long — Primary key — NOT NULL
- time (시간) — LocalDateTime
- content (내용) — String
Member (구성원)
- member_id (멤버id) — long — Primary key — NOT NULL
- eng_name (영문이름) — string
- kor_name (한글이름) — String
- department (소속) — String
- major (전공) — String
- homepage (홈페이지) — String
- position (직책) — String
- profile (프로필사진) — image
- email (이메일) — String
- DTYPE (구분컬럼) — long
- imageUrl (s3에저장한이미지url) — String
- office (연구실주소) — String
- login_id (로그인id) — String
- login_pw (로그인pw) — String
- deleted (탈퇴여부) — boolean
- Fields (연구분야) — String
attach (첨부파일)
- attach_id (첨부파일 id) — long — Primary key — NOT NULL
- post_id (게시글id) — long — Foreign key → post.post_id — NOT NULL
- member_id (멤버id) — long — Foreign key → post.member_id — NOT NULL
- board_id (게시판id) — long — Foreign key → post.board_id — NOT NULL
- path (첨부파일경로) — String
- origin_name (원본파일이름) — String
- server_name (서버파일이름) — String
board (게시판)
- board_id (게시판id) — long — Primary key — NOT NULL
- name (게시판이름) — String
demo (데모)
- demo_id (데모id) — long — Primary key — NOT NULL
- content (내용) — text
- name (데모명) — String
- url (데모url) — String
- participants (참여자) — String
- field_id (연구분야id) — long — Foreign key → field.field_id — NOT NULL
field (연구분야)
- field_id (연구분야id) — long — Primary key — NOT NULL
- description (연구분야설명) — text
- field_name (연구분야명) — String
post (게시글)
- post_id (게시글id) — long — Primary key — NOT NULL
- member_id (멤버id) — long — Foreign key → Member.member_id — NOT NULL
- board_id (게시판id) — long — Foreign key → board.board_id — NOT NULL
- upload_data (업로드날짜) — LocalDateTime
- title (게시글제목) — String
- content (게시글내용) — text
- view_number (조회수) — int
- files (첨부파일) — List<image>
project (프로젝트)
- project_id (프로젝트id) — long — Primary key — NOT NULL
- content (프로젝트내용) — text
- project_name (프로젝트명) — String
- Participants (참여자) — String
- field_id (연구분야id) — long — Foreign key → field.field_id — NOT NULL
thesis (논문)
- thiesis_id (논문id) — long — Primary key — NOT NULL
- title (논문제목) — String
- academic_journal_name (학술지명) — String
- release_date (발표일) — String
- url — String
- field_id (연구분야id) — long — Foreign key → field.field_id — NOT NULL
thesis_member (thesis, member의 중간테이블)
- thesis_member_Id (조인테이블id) — long — Primary key — NOT NULL
- thiesis_id (논문id) — long — Foreign key → thesis.thiesis_id — NOT NULL
- member_id (멤버id) — long — Foreign key → Member.member_id — NOT NULL