SCHMA
Tables (10)
Exhibition (Untitled6)
- Key (id) — UUID — Primary key — NOT NULL
- Field (exhibitionName) — String
- Field2 (exhibitionImage) — String?
- Field (exhibitionStartDate) — Date
- Field2 (exhibitionEndDate) — Date
- Field3 (exhibitionDescription) — String?
- Field4 (exhibitionBookmark) — Bool
- Field5 (exhibitionInterest) — Interest
- Field (exhibitionLocation) — [Location]
- Key — Foreign key → UserProfile.Key — NOT NULL
- PK (id2) — UUID — Foreign key → UserProfile.PK — NOT NULL
Follower (Untitled4)
- 팔로워유저아이디 (followerName) — String
- 팔로워유저닉네임 (followerNickname) — String?
- 팔로잉상태 (followerStatus) — Bool
- Key — Foreign key → UserProfile.Key — NOT NULL
- PK (id) — UUID — Foreign key → UserProfile.PK — NOT NULL
Follwing (Untitled3)
- 팔로잉유저아이디 (followingName) — String
- 팔로잉유저닉네임 (followingNickname) — String?
- 팔로잉상태 (followingStatus) — Bool
- Key — Foreign key → UserProfile.Key — NOT NULL
- PK (id) — UUID — Foreign key → UserProfile.PK — NOT NULL
Interest (Untitled5)
- Key — Primary key — NOT NULL
- 관심사ID (interestID) — UUID
- 관심사이름 (interestName) — String
- 관심사색 (interestColor) — Color
- 관심사넓이 (interestWidth) — Double
- Key (Key2) — Foreign key → UserProfile.Key — NOT NULL
- PK (id) — UUID — Foreign key → UserProfile.PK — NOT NULL
Location (Untitled7)
- Key (id) — UUID — Foreign key → Exhibition.Key — NOT NULL
- Field (locationName) — String
- Field2 (locationAddress) — String
- Field3 (locationDescription) — String
- Field4 (locationSite) — String
Review (Untitled8)
- Field (reviewID) — UUID
- 리뷰작성자 (reviewAuthor) — String
- 리뷰내용 (reviewContent) — String
- 리뷰이미지 (reviewImage) — String?
- 리뷰시간 (reviewTime) — Date
- Key (Key2) — Foreign key → UserProfile.Key — NOT NULL
- PK (id) — UUID — Foreign key → UserProfile.PK — NOT NULL
User (Untitled)
- PK (id) — UUID — Primary key — NOT NULL
- 아이디 (userName) — String
- 비밀번호 (password) — String
- 이메일 (email) — String
UserProfile (Untitled2)
- Key — Primary key — NOT NULL
- PK (id) — UUID — Foreign key → User.PK — NOT NULL
- 프로필이미지 (userImage) — String?
- 닉네임 (userNickname) — String?
- 관심사 (userIntersts) — [Interest]
- 소개 (userIntroduction) — String?
- 위치 (userLocation) — String?
- AboutMe (userAboutMe) — String?
- 프로필색상 (userColor) — Color
- 활동이력 (userActivities)
- 리뷰 (userReviews) — [Review]
- 본전시 (userSeendExhibitions)
- 북마크전시 (userBookmarkExihibitions) — [Exhibition]
- 팔로잉 (userFollowings) — [Following]
- 팔로워 (userFollowers) — [Follower]
- Field (userWallets) — [Wallet]
Wallet (Untitled10)
- Key — Foreign key → UserProfile.Key — NOT NULL
- PK (id) — UUID — Foreign key → UserProfile.PK — NOT NULL
- Field
- Field2
- Field3
- Field4