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)