sumsum

Tables (6)

Untitled (Post)

  • Key (post_id) — number — Primary key — NOT NULL
  • Key (user_id) — number — Foreign key → User.Key — NOT NULL
  • Field (Title) — string
  • Field (description) — string
  • Field (location) — string
  • Field (xLocation) — number
  • Field (yLocation) — number
  • Field (rentalFee) — number
  • Field (buildingType) — string
  • Field (floors) — string
  • Field (roomType) — string
  • Field (residentStartDate) — timestamp
  • Field (residentFinishDate) — timestamp
  • Field (gender) — number
  • Field2 (smoking) — number
  • Field (isDealt) — boolean

Untitled (Feature)

  • Key (feature_id) — number — Primary key — NOT NULL
  • Key (post_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (text) — string

Untitled (Picture)

  • Key (picture_key) — number — Primary key — NOT NULL
  • Key (post_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (url) — string

Untitled (Option)

  • Key (option_key) — number — Primary key — NOT NULL
  • Key (post_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (text) — string

Untitled (Chatroom)

  • Key (chatroom_id) — number — Primary key — NOT NULL
  • Key (post_id) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id2) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — number — Foreign key → User.Key — NOT NULL
  • Field (chatroomKey) — string

User

  • Key (user_id) — number — Primary key — NOT NULL
  • Field (name) — string
  • Field (nickname) — string
  • Field (email) — string
  • Field2 (isPhoneAuthDone) — boolean
  • Field (isUnivAuthDone) — boolean
  • Field3 (isNicknameSettingDone) — boolean
  • Field4 (isPosted) — boolean
  • Field (wishLocation) — string
  • Field2 (xLocation) — number
  • Field3 (yLocation) — number