test

Tables (10)

User (user)

  • 아이디 (id) — Bigint — Primary key — NOT NULL
  • 이름 (username) — varchar — NOT NULL
  • 이메일 (email) — varchar — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 생성일 (created_time) — DateTime — NOT NULL
  • 수정일 (updated_time) — DateTime — NOT NULL

comments

  • 아이디 (id) — BIGINT — Primary key — NOT NULL
  • 포스트아이디 (post_id) — BIGINT — Foreign key → posts.아이디 — NOT NULL — on delete cascade
  • 유저아이디 (user_id) — Bigint — Foreign key → posts.유저아이디 — NOT NULL — on delete cascade
  • 내용 (contetn) — text — NOT NULL
  • 생성일 (created_time) — timestamp — NOT NULL
  • 수정일 (updated_time) — timestamp — NOT NULL — on update current_timestamp
  • Field

dislike

  • 아이디 (dislikes_id) — BIGINT — Primary key — NOT NULL
  • 아이디 (post_id) — BIGINT — Foreign key → posts.아이디 — NOT NULL — on delete cascade
  • 유저아이디 (user_id) — Bigint — Foreign key → posts.유저아이디 — NOT NULL — on delete cascade
  • 생성일 (created_time) — timestamp

education

  • 락혁id (education_id) — BIGINT — Primary key — NOT NULL
  • 프로필id (profile_id) — Bigint — Foreign key → profiles.아이디 — NOT NULL — on delete cascade
  • id (id2) — bigint — Foreign key → profiles.직무 — NOT NULL
  • 교육 (school) — varchar — NOT NULL
  • 학점 (degree) — varchar — NOT NULL
  • 전공 (major) — varchar
  • 시작일 (start_date) — date — NOT NULL
  • 종료일 (end_date) — date — NOT NULL

experience

  • 경력id (experience_id) — BIGINT — Primary key — NOT NULL
  • 프로필id (profile_id) — Bigint — Foreign key → profiles.아이디 — NOT NULL — on delete cascade
  • id (id2) — bigint — Foreign key → profiles.직무 — NOT NULL
  • 회사 (company) — varchar — NOT NULL
  • 직업 (job_title) — varchar — NOT NULL
  • 직종 (position) — varchar
  • 시작일 (start_date) — date — NOT NULL
  • 종료일 (end_date) — date — NOT NULL
  • 직종설명 (description) — text

likes

  • 아이디 (likes_id) — BIGINT — Primary key — NOT NULL
  • 아이디 (post_id) — BIGINT — Foreign key → posts.아이디 — NOT NULL — on delete cascade
  • 유저아이디 (user_id) — Bigint — Foreign key → posts.유저아이디 — NOT NULL — on delete cascade
  • 생성일 (created_time) — timestamp

posts

  • 아이디 (post_id) — BIGINT — Primary key — NOT NULL
  • 유저아이디 (user_id) — Bigint — Foreign key → User.아이디 — NOT NULL — on delete cascade
  • 내용 (content) — text — NOT NULL
  • 생성일 (created_time) — timestamp — NOT NULL
  • 수정일 (updated_time) — timestamp — NOT NULL — on update current_timestamp

profile_status

  • id — bigint — Primary key — NOT NULL
  • code — varchar(50) — NOT NULL
  • label — varchar(100) — NOT NULL

profiles

  • 프로필id (profile_id) — BIGINT — Primary key — NOT NULL
  • 아이디 (user_id) — Bigint — Foreign key → User.아이디 — NOT NULL — on delete cascade
  • 직무 (status) — varchar(50) — Foreign key → profile_status.id — NOT NULL
  • 웹사이트 (website) — varchar
  • 지역 (location) — varchar
  • 기술 (skills) — varchar
  • 깃허브 이름 (github_username) — varchar
  • 바이오 (bio) — text
  • 이미지 (image) — varchar
  • 생성일 (created_time) — timestamp — NOT NULL
  • 수정일 (update_time) — timestamp — NOT NULL

social_link

  • 아이디 (social_id) — BIGINT — Primary key — NOT NULL
  • 아이디 (id) — Bigint — Foreign key → profiles.아이디 — NOT NULL — on delete cascade
  • id (id2) — bigint — Foreign key → profiles.직무 — NOT NULL
  • 트위터 (twitter) — varchar
  • 페이스북 (facebook) — varchar
  • 유뷰트 (youtube) — varchar
  • 링크드인 (linkedin) — varchar