zzzz
Tables (8)
adddress (Untitled)
- addressld (Key) — int — Primary key — NOT NULL
- userld (Key2) — int — Foreign key → user.userld — NOT NULL
- created (Field2) — timestamp
- admission (Field3) — Varchat(20)
category (Untitled6)
- categoryld (Key) — int — Primary key — NOT NULL
- categoryName (Field) — Varchar(20)
- created (Field2) — timestamp
- updated (Field3) — timestamp
- stasus (Field4) — Varchar(20)
chatting room (Untitled8)
- chatting roomld (Key) — int — Primary key — NOT NULL
- userld (Key2) — int — Foreign key → user.userld — NOT NULL
- postld (Key3) — int — Foreign key → post.postld — NOT NULL
- categoryld (Key22) — int — Foreign key → post.categoryld — NOT NULL
- userld (Key32) — int — Foreign key → post.userld — NOT NULL
- sellerUserld (Field2) — int
- buyerUserid (Field3) — int
- created (Field) — timestamp
- status (Field5) — varchar(20)
interestCatagory (Untitled5)
- interestCatagory (Key) — int — Primary key — NOT NULL
- userld (Key2) — int — Foreign key → user.userld — NOT NULL
- categoryld (Key3) — int — Foreign key → category.categoryld — NOT NULL
- created (Field3) — timestamp
- status (Field4) — varchar
post (Untitled7)
- postld (Key) — int — Primary key — NOT NULL
- categoryld (Key2) — int — Foreign key → category.categoryld — NOT NULL
- userld (Key3) — int — Foreign key → user.userld — NOT NULL
- userld (Field) — int
- title (Field2) — varchar(100)
- cost (Field4) — int
- content (Field5) — text
- created (Field6) — timestamp
- updated (Field7) — timestamp
- status (Field8) — varchar(20)
town (Untitled2)
- townld (Key) — int — Primary key — NOT NULL
- interestCatagory (Key2) — int — Foreign key → interestCatagory.interestCatagory — NOT NULL
- userld (Key22) — int — Foreign key → interestCatagory.userld — NOT NULL
- categoryld (Key3) — int — Foreign key → interestCatagory.categoryld — NOT NULL
- city (Field) — Varchar(20)
- district (Field2) — Varchar(20)
- townName (Field3) — Varchar(20)
- latitude (Field4) — Float
- longitude (Field5) — Float
user (Untitled4)
- userld (Key) — int — Primary key — NOT NULL
- phoneNumber (Field) — Char(11)
- Nickname (Field2) — Varchar(36)
- email (Field3) — varchar(50)
- updated (Field4) — timestamp
- status (Field5) — varchar(20)
wishlist (Untitled3)
- wishlistld (Key) — int — Primary key — NOT NULL
- userld (Key2) — int — Foreign key → user.userld — NOT NULL
- postld (Key3) — int — Foreign key → post.postld — NOT NULL
- categoryld (Key22) — int — Foreign key → post.categoryld — NOT NULL
- userld (Key32) — int — Foreign key → post.userld — NOT NULL
- created (Field3) — timestamp
- updated (Field4) — timestamp
- status (Field5) — Varchar(20)