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