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