IA
Tables (13)
Comment (Untitled8)
- CommentId (Key) — Long — Primary key — NOT NULL
- content (Field) — String — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
JobOpen (Untitled2)
- JobOpenId (Key) — Long — Primary key — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- title (Field) — String — NOT NULL
- recruitment_start_date (Field2) — Date — NOT NULL
- recruitment_end_date (Field3) — Date — NOT NULL
- recruitment_count (Field4) — int — NOT NULL
- model_type (Field5) — enum — NOT NULL
- genre (Field6) — enum — NOT NULL
- payment (Field7) — enum — NOT NULL
- goal (Field8) — eunm — NOT NULL
- desired_location (Field9) — enum — NOT NULL
- desired_time (Field10) — int — NOT NULL
- design_draft (Field11) — enum — NOT NULL
- portfolio_link (Field12) — enum — NOT NULL
- work_limitations (Field13) — String
- introduction (Field14) — String
- image_URL (Field15) — String
- region (Field16) — String — NOT NULL
- required_materials (Field17) — String
- createdAt (Field18) — Datetime — NOT NULL
- updatedAt (Field19) — Datetime — NOT NULL
JobOpenMatching (Untitled9)
- RequestId (Key) — Long — Primary key — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- JobOpenId (Key2) — Long — Foreign key → JobOpen.JobOpenId — NOT NULL
- introduction (Field) — String — NOT NULL
- createdAt (Field2) — Datetime — NOT NULL
- status (Field3) — enum
JobOpen_Keyword (Untitled6)
- Key — Primary key — NOT NULL
- keywordId (Key2) — Long — Foreign key → Keyword.keywordId — NOT NULL
- JobOpenId (Key3) — Long — Foreign key → JobOpen.JobOpenId — NOT NULL
JobSearch (Untitled3)
- JobSearchId (Key) — Long — Primary key — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- title (Field) — String — NOT NULL
- recruitment_start_date (Field2) — Date — NOT NULL
- recruitment_end_date (Field3) — Date — NOT NULL
- recruitment_count (Field4) — int — NOT NULL
- model_type (Field5) — enum — NOT NULL
- genre (Field6) — enum — NOT NULL
- payment (Field7) — enum — NOT NULL
- goal (Field8) — enum — NOT NULL
- desired_location (Field9) — enum — NOT NULL
- desired_time (Field10) — int — NOT NULL
- design_draft (Field11) — enum — NOT NULL
- portfolio_link (Field12) — enum — NOT NULL
- work_limitations (Field13) — String
- introduction (Field14) — String
- image_URL (Field15) — String
- createdAt (Field16) — Datetime — NOT NULL
- updatedAt (Field17) — Datetime — NOT NULL
JobSearchMatching (Untitled10)
- RequestId (Key) — Long — Primary key — NOT NULL
- JobSearchId (Key2) — Long — Foreign key → JobSearch.JobSearchId — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- introduction (Field) — String — NOT NULL
- createdAt (Field2) — Datetime — NOT NULL
- status (Field3) — enum
JobSearch_keyword (Untitled7)
- Key — Primary key — NOT NULL
- keywordId (Key2) — Long — Foreign key → Keyword.keywordId — NOT NULL
- JobSearchId (Key3) — Long — Foreign key → JobSearch.JobSearchId — NOT NULL
Keyword (Untitled4)
- keywordId (Key) — Long — Primary key — NOT NULL
- content (Field) — enum — NOT NULL
Pfrofile (Profile)
- profileId (id) — Long — Primary key — NOT NULL
- userId (id2) — Long — Foreign key → User.userId — NOT NULL
- profile_image_URL — text — NOT NULL
- description — text
- region — String — NOT NULL
- vibe (vibe) — String — NOT NULL
- length — int — NOT NULL
- size — String — NOT NULL
- charactor — String — NOT NULL
- hairStyle (Field) — String — NOT NULL
- hairColor (Field2) — String — NOT NULL
- charmingPointS (Field3) — String — NOT NULL
- style (Field4) — String — NOT NULL
- footSize (Field6) — int
- createdAt (Field7) — datetime — NOT NULL
- updatedAt (Field8) — datetime — NOT NULL
- visibleYN (Field9) — boolean — NOT NULL
Post (Untitled)
- postId (Key) — Long — Primary key — NOT NULL
- userId (id) — Long — Foreign key → User.userId — NOT NULL
- type (Field) — enum — NOT NULL
- title (Field2) — String — NOT NULL
- content (Field3) — String — NOT NULL
- createdAt (Field4) — datetime — NOT NULL
- updatedAt (Field5) — datetime — NOT NULL
- view_count (Field6) — int — NOT NULL
Profile_keyword (Untitled5)
- profile_keywordId (Key2) — Long — Primary key — NOT NULL
- profileId (id) — Long — Foreign key → Pfrofile.profileId — NOT NULL
- keywordId (Key) — Long — Foreign key → Keyword.keywordId — NOT NULL
SharedCalender (Untitled11)
- SharedCalenderId (Key) — Long — Primary key — NOT NULL
- schedule_date (Field) — DateTime — NOT NULL
- location (Field2) — String — NOT NULL
- note (Field3) — String — NOT NULL
User
- userId (id) — Long — Primary key — NOT NULL
- email — String — NOT NULL
- username — String — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- activeStatus (activateStatus) — bool — NOT NULL
- rating_score (Field) — numberic — NOT NULL
- role (Field2) — enum — NOT NULL
- activated (Field3) — bool — NOT NULL
- gender (Field4) — enum — NOT NULL
- age (Field5) — int — NOT NULL
- birthday (Field6) — Date — NOT NULL
- nickName (Field7) — String — NOT NULL
- type (Field8) — Enum — NOT NULL