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