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