스타 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