meetpl_test
Tables (9)
career (경력)
- career_id (Key) — bigint — Primary key — NOT NULL
- content (Field) — text
- reviewer_id (Key2) — bigint — Foreign key → reviewer.reviewer_id — NOT NULL
code_review (코드리뷰)
- code_review_id (Key) — Primary key — NOT NULL
- reviewer_id (Key2) — bigint — Foreign key → reviewer.reviewer_id — NOT NULL
- request (Field) — text
- project_info (Field2) — text
memeber (유저)
- member_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — text
- profile (Field2) — text
- email (Field3) — text
- phone (Field4) — text
- type (Field5) — enum
review (리뷰이)
- review_id (Key) — bigint — Primary key — NOT NULL
- start_date (Field) — Local_date
- end_date (Field4) — Local_date
- application_form_link (Field2) — text
- chatting_link (Field3) — text
- member_id (Key2) — bigint — Foreign key → memeber.member_id — NOT NULL
- code_review_id (Key3) — Foreign key → code_review.code_review_id — NOT NULL
review_content (후기)
- review_content_id (Key) — bigint — Primary key — NOT NULL
- content (Field) — text
- gpa (Field2) — int
- review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
review_skill (리뷰스택)
- review_skill_id (Key) — bigint — Primary key — NOT NULL
- skill_type (Field) — enum
- code_review_id (Key2) — Foreign key → code_review.code_review_id — NOT NULL
review_tag (리뷰태그)
- review_tag_id (Key) — bigint — Primary key — NOT NULL
- review_type (Field) — enum
- review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
reviewer (리뷰어)
- reviewer_id (Key) — bigint — Primary key — NOT NULL
- corporation (Field) — text
- enter_date (Field2) — Local_date
- github_link (Field3) — text
- intro (Field4) — text
- code_style (Field5) — text
- review_count (Field6) — int
- review_content_count (Field7) — int
- job (Field8) — enum
- member_id (Key2) — bigint — Foreign key → memeber.member_id — NOT NULL
skill (기술스택)
- skill_id (Key) — bigint — Primary key — NOT NULL
- skill_type (Field) — enum
- reviewer_id (Key2) — bigint — Foreign key → reviewer.reviewer_id — NOT NULL