종설DB

테이블 (26)

academic_schedule (학사일정)

  • academic_schedule_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(100), not null
  • schedule (Field2) — VARCHAR(100), not null
  • start_at (Field4) — TIMESTAMP
  • end_at (Field3) — TIMESTAMP
  • created_at (Field5) — TIMESTAMP, not null

article (게시글)

  • article_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • board_index (Key3) — serial — 외래 키 → board.board_index — NOT NULL
  • title (Field) — VARCHAR(50), not null
  • contents (Field2) — TEXT, not null
  • created_at (Field3) — TIMESTAMP, not null

article_bookmark (게시글 스크랩)

  • article_bookmark_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_index (Key3) — serial — 외래 키 → article.article_index — NOT NULL
  • (user_index, article_index) (Field) — unique
  • created_at (Field2) — TIMESTAMP, not null

article_comment (게시글 댓글)

  • article_comment_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_index (Key3) — serial — 외래 키 → article.article_index — NOT NULL
  • contents (Field) — TEXT, not null
  • created_at (Field2) — TIMESTAMP, not null

article_comment_complain (게시글 댓글 신고하기)

  • article_comment_complain_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_comment_index (Key3) — serial — 외래 키 → article_comment.article_comment_index — NOT NULL
  • (user_index, article_comment_index) (Field) — unique
  • contents (Field2) — TEXT, not null
  • created_at (Field3) — TIMESTAMP, not null

article_comment_favorite (게시글 댓글 좋아요)

  • article_comment_favorite_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_comment_index (Key3) — serial — 외래 키 → article_comment.article_comment_index — NOT NULL
  • (user_index, article_comment_index) (Field) — unique

article_complain (게시글 신고하기)

  • article_complain_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_index (Key3) — serial — 외래 키 → article.article_index — NOT NULL
  • (user_index, article_index) (Field) — unique
  • contents (Field3) — TEXT, not null
  • created_at (Field2) — TIMESTAMP, not null

article_favorite (게시글 좋아요)

  • article_favorite_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • article_index (Key3) — serial — 외래 키 → article.article_index — NOT NULL
  • (user_index, article_index) (Field) — unique

article_img (게시글 이미지)

  • article_img_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • article_index (Key2) — serial — 외래 키 → article.article_index — NOT NULL
  • img_url (Field) — VARCHAR(255), not null
  • created_at (Field2) — TIMESTAMP, not null

board (게시판)

  • board_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(20), not null
  • created_at (Field2) — TIMESTAMP, not null

board_bookmark (게시판 즐겨찾기)

  • board_bookmark_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • board_index (Key3) — serial — 외래 키 → board.board_index — NOT NULL
  • (user_index, board_index) (Field) — unique

contest (대회)

  • contest_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(100), not null
  • start_at (Field3) — TIMESTAMP
  • end_at (Field4) — TIMESTAMP
  • information_url (Field6) — VARCHAR(255)
  • created_at (Field5) — TIMESTAMP, not null

department (학과)

  • department_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(20), not null

field (대회 분야)

  • field_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(30), not null

field_of_contest (대회에 매핑된 분야)

  • field_of_contest_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • contest_index (Key2) — serial — 외래 키 → contest.contest_index — NOT NULL
  • field_index (Key3) — serial — 외래 키 → field.field_index — NOT NULL
  • contest_index, field_index) (Field) — unique

friend (친구 관계)

  • friend_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • from_user_index (Field2) — Long, not null
  • to_user_index (Field5) — Long, not null
  • (from_user_index, to_user_index) (Field3) — unique
  • is_friend (Field4) — Boolean, not null

hobby (취미)

  • hobby_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(30), not null
  • score (Field2) — INT, not null

hobby_of_user (유저에 매핑된 취미)

  • hobby_of_user_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • hobby_index (Key3) — serial — 외래 키 → hobby.hobby_index — NOT NULL
  • (user_index, hobby_index) (Field) — unique

professor (교수)

  • professor_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • department_index (Key2) — serial — 외래 키 → department.department_index — NOT NULL
  • name (Field) — VARCHAR(5), not null

region (거주지역)

  • region_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(20), not null

region_of_user (유저에 매핑된 거주지역)

  • region_of_user_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • region_index (Key3) — serial — 외래 키 → region.region_index — NOT NULL
  • (user_index, region_index) (Field) — unique

subject (과목)

  • subject_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • department_index (Key2) — serial — 외래 키 → department.department_index — NOT NULL
  • professor_index (Key3) — serial — 외래 키 → professor.professor_index — NOT NULL
  • name (Field) — VARCHAR(30), not null
  • subject_type (Field2) — VARCHAR(20), not null
  • evaluation_type (Field6) — Boolean, not null
  • school_year (Field4) — INT, not null
  • semester (Field3) — Boolean, not null
  • is_online (Field5) — Boolean, not null

subject_boomark (저장한 과목)

  • subject_bookmark_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • subject_index (Key3) — serial — 외래 키 → subject.subject_index — NOT NULL
  • (user_index, subject_index) (Field) — unique
  • created_at (Field2) — TIMESTAMP, not null

subject_review (과목 수강 후기)

  • subject_review_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • subject_index (Key3) — serial — 외래 키 → subject.subject_index — NOT NULL
  • (user_index, subject_index) (Field) — unique
  • title (Field2) — VARCHAR(50), not null
  • contents (Field3) — TEXT, not null
  • rating (Field4) — INT, not null
  • created_at (Field5) — TIMESTAMP, not null

subject_taken (수강한 과목)

  • subject_taken_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • user_index (Key2) — serial — 외래 키 → users.user_index — NOT NULL
  • subject_index (Key3) — serial — 외래 키 → subject.subject_index — NOT NULL
  • (user_index, subject_index) (Field) — unique
  • school_year (Field2) — INT, not null
  • semester (Field3) — Boolean, not null
  • rating (Field5) — INT, not null
  • created_at (Field4) — TIMESTAMP, not null

users (유저)

  • user_index (Key) — serial, primary key — 기본 키 — NOT NULL
  • department_index (Key2) — serial — 외래 키 → department.department_index — NOT NULL
  • email (Field) — VARCHAR(40), unique, not null
  • password (Field2) — VARCHAR(255), not null
  • nickname (Field3) — VARCHAR(30), unique, not null
  • school_year (Field5) — INT, not null
  • age (Field6) — INT, not null
  • gender (Field7) — Boolean, not null
  • created_at (Field8) — TIMESTAMP, not null