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)