스타 D 링크
테이블 (10)
User (users)
- user_id (Key) — bigint — 기본 키 — NOT NULL
- nickname (Field3) — varchar(40) — NOT NULL
- username (Field) — varchar(20) — NOT NULL
- password (Field2) — varchar(250) — NOT NULL
- email (Field4) — varchar(40) — NOT NULL
- profile_url (Field6) — varchar(250)
- phone_number (Field7) — varchar(20) — NOT NULL
- birth_date (Field8) — varchar(20) — NOT NULL
- region (Field9) — varchar(100) — NOT NULL
- created_at (Field11) — timestamp — NOT NULL
- updated_at (Field12) — timestamp — NOT NULL
board (boards)
- board_id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → User.user_id — NOT NULL
- like_count (Field) — int — NOT NULL
- title (Field7) — varchar(30) — NOT NULL
- content (Field2) — text — NOT NULL
- hashtag (Field3) — text
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
- post_type (Field6) — int — NOT NULL
comment (comments)
- comment_id (Key) — bigint — 기본 키 — NOT NULL
- board_id (Key2) — bigint — 외래 키 → board.board_id — NOT NULL
- user_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
- study_board_id (Key4) — 외래 키 → study_board.study_board_id
- content (Field) — text — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
course_review (Untitled4)
- course_review_id (Key) — bigint — 기본 키 — NOT NULL
- board_id (key2) — bigint — 외래 키 → board.board_id — NOT NULL
- rating (Field) — int — NOT NULL
- name (Field2) — varchar(50) — NOT NULL
file (Untitled)
- image_id (Key) — bigint — 기본 키 — NOT NULL
- board_id (Key2) — bigint — 외래 키 → board.board_id — NOT NULL
- study_board_id (Key3) — 외래 키 → study_board.study_board_id
- file_url (Field) — varchar(250) — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
follow (Untitled5)
- follow_id (Key) — bigint — 기본 키 — NOT NULL
- follower (Key2) — bigint — 외래 키 → User.user_id — NOT NULL
- followee (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
likes (Untitled6)
- likes_id (Key) — bigint — 기본 키 — NOT NULL
- board_id (Key2) — bigint — 외래 키 → board.board_id — NOT NULL
- user_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
study (Untitled2)
- study_id (Key) — bigint — 기본 키 — NOT NULL
- board_id (Key2) — bigint — 외래 키 → board.board_id — NOT NULL
- is_recruit (Field) — boolean — NOT NULL
- region (Field2) — varchar(100)
- is_online (Field3) — boolean — NOT NULL
- headcount (Field4) — int — NOT NULL
study_board (Untitled7)
- study_board_id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → User.user_id — NOT NULL
- study_id (Key3) — bigint — 외래 키 → study.study_id — NOT NULL
- title (Field) — varchar(20) — NOT NULL
- content (Field2) — text — NOT NULL
- hashtag (Field3) — text — NOT NULL
study_manage (Untitled3)
- study_manage_id (Key) — 기본 키 — NOT NULL
- user_id (Key3) — bigint — 외래 키 → User.user_id — NOT NULL
- study_id (Key2) — bigint — 외래 키 → study.study_id — NOT NULL