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

Record (Untitled9)

  • Field
  • Field2
  • Field3
  • Field4

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