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