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