danggeun

Tables (6)

chatroom (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.id — NOT NULL

district (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • city (Field2) — varchar

image (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • type (Field) — varchar
  • url (Field2) — varchar

message (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key3) — int — Foreign key → chatroom.id — NOT NULL
  • id (Key32) — int — Foreign key — NOT NULL
  • content (Field) — varchar
  • messagedate (Field2) — timestamp
  • uid (Key2) — int — Foreign key → users.uid — NOT NULL
  • district_id (Key22) — int — Foreign key → users.district_id — NOT NULL

product (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • users_uid (Key2) — int — Foreign key → users.uid — NOT NULL
  • district_id (Key22) — int — Foreign key → users.district_id — NOT NULL
  • image_id (Key3) — int — Foreign key → image.id — NOT NULL
  • title (Field) — varchar
  • price (Field2) — int
  • text (Field3) — varchar
  • image_url (Field4) — varchar
  • created_time (Field5) — timestamp
  • status (Field6) — boolean
  • views (Field7) — int

users (Untitled2)

  • uid (Key) — int — Primary key — NOT NULL
  • district_id (Key2) — int — Foreign key → district.id — NOT NULL
  • id (Field) — varchar
  • name (Field2) — varchar
  • created_date (Field3) — timestamp
  • email (Field4) — varchar
  • sex (Field5) — char
  • order_history (Field6) — varchar
  • cellphone_num (Field7) — varchar