careerload

Tables (10)

career_category

  • id (Key) — bigint — Primary key — NOT NULL
  • area (Field) — enum
  • name (Field2) — varchar

comment

  • id (Key) — bigint — Primary key — NOT NULL
  • content (Field) — text — NOT NULL
  • level (Field2) — bigint
  • member_id (key) — bigint — Foreign key → member.id — NOT NULL
  • roadmap_id (Key2) — bigint — Foreign key → roadmap.id — NOT NULL
  • comment_id (Key3) — bigint — Foreign key → comment.id — NOT NULL

follow

  • id (Key) — bigint — Primary key — NOT NULL
  • follwer_id (key) — bigint — Foreign key → member.id — NOT NULL
  • followee_id (key2) — bigint — Foreign key → member.id — NOT NULL

interest_career

  • id (Key) — bigint — Primary key — NOT NULL
  • Field
  • career_category_id (Key2) — Foreign key → career_category.id — NOT NULL
  • member_id (key) — bigint — Foreign key → member.id — NOT NULL

member

  • id (key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar — NOT NULL
  • birth_date (Field2) — date
  • gender (Field3) — int
  • status (Field4) — int

member_roadmap

  • id (Key) — bigint — Primary key — NOT NULL
  • status (Field) — int — NOT NULL
  • roadmap_id (Key2) — bigint — Foreign key → roadmap.id — NOT NULL
  • member_id (key) — bigint — Foreign key → member.id — NOT NULL
  • now_step (Field2) — int
  • Field3

roadmap

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar
  • description (Field2) — text
  • member_id (key) — bigint — Foreign key → member.id — NOT NULL

roadmap_category

  • id (Key) — bigint — Primary key — NOT NULL
  • career_category_id (Key2) — bigint — Foreign key → career_category.id — NOT NULL
  • roadmap_id (Key3) — Foreign key → roadmap.id — NOT NULL

roadmap_like

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (key) — bigint — Foreign key → member.id — NOT NULL
  • road_map_id (Key2) — bigint — Foreign key → roadmap.id — NOT NULL

roadmap_step

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — text
  • step_number (Field3) — int — NOT NULL
  • roadmap_id (Key2) — bigint — Foreign key → roadmap.id — NOT NULL