종설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