UMC_MEETPICK

Tables (11)

Copy Of Member_Profile (CopyOfCopyOfUntitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — string
  • profile_image (Field2) — string
  • enroll_year (Field3) — INT
  • MBTI (Field4) — enum
  • hobby (Field6) — enum
  • contact (Field7) — enum
  • contactInfo (Field8) — string
  • major (Key2) — Long — Foreign key → Major.id — NOT NULL

Copy Of Member_Profile2 (CopyOfCopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — string
  • profile_image (Field2) — string
  • enroll_year (Field3) — INT
  • MBTI (Field4) — enum
  • hobby (Field6) — enum
  • contact (Field7) — enum
  • contactInfo (Field8) — string
  • major (Key2) — Long — Foreign key → Major.id — NOT NULL

List (CopyOfUntitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → Member_Profile.id — NOT NULL
  • 요청하는 정보들 (Field)

Major (CopyOfCopyOfUntitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field8) — string
  • sub_major (Key2) — sub_major — Foreign key → Sub_Major.id — NOT NULL

Member (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • gender (Field) — enum
  • birthday (Field2) — Date
  • age (Field3) — INT
  • university (Field4) — String
  • socialType (Field5) — enum
  • socialId (Field6) — Long
  • status (Field7) — boolean
  • role (Field8) — List<role>
  • refreshToken (Field9)
  • memberProfile (Key2) — memberProfile — Foreign key → Member_Profile.id — NOT NULL

Member_Mapping (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • senderId (Key2) — Long — Foreign key → Member_Profile.id — NOT NULL
  • receiverId (Key3) — Long — Foreign key → Copy Of Member_Profile.id — NOT NULL
  • type (Field) — enum
  • createdAt (Field2)
  • isMatched (Field3) — boolean
  • 부모 리스트 id (Key4) — List — Foreign key → List.id — NOT NULL

Member_Profile (CopyOfUntitled)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — string
  • profile_image (Field2) — string
  • enroll_year (Field3) — INT
  • MBTI (Field4) — enum
  • hobby (Field6) — enum
  • contact (Field7) — enum
  • contactInfo (Field8) — string
  • major (Key2) — Long — Foreign key → Major.id — NOT NULL

Sub_Major (CopyOfCopyOfCopyOfUntitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field8) — string

alarm (CopyOfUntitled22)

  • id (Key) — Long — Primary key — NOT NULL
  • type (Field) — enum
  • createdAt (Field2)
  • 매핑 정보 (Key2) — Long — Foreign key → Member_Mapping.id — NOT NULL

report (CopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • writer (Key2) — Member — Foreign key → Member_Profile.id — NOT NULL
  • written (Key3) — Member — Foreign key → Copy Of Member_Profile2.id — NOT NULL
  • content (Field)
  • createdAt (Field2)

review (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • writer (Key2) — Member — Foreign key → Member_Profile.id — NOT NULL
  • written (Key3) — Member — Foreign key → Copy Of Member_Profile2.id — NOT NULL
  • content (Field)
  • createdAt (Field2)