minproject

Tables (4)

Untitled (category)

  • Key (ca_id) — Long — Primary key — NOT NULL
  • Field (ca_name) — varchar(255)
  • Field2 (ca_num) — int

Untitled (likes)

  • Key (likes_id) — Long — Primary key — NOT NULL
  • Field (user_id) — Long — Foreign key → User.Field

Untitled (loan_product)

  • Key (product_id) — Long — Primary key — NOT NULL
  • Field (loan_type)

User (user)

  • Field (user_id) — Long — Primary key
  • Field2 (user_name) — varchar(128)
  • Field3 (email) — varchar(255)
  • Field4 (password) — varchar(255)
  • Field5 (birth) — varchar(255)
  • Field6 (asset) — int
  • Field (income) — int
  • Field (job) — varchar(255)
  • Field (region) — varchar(255)
  • Field (why_join) — int