loan

Tables (3)

Loan (Untitled2)

  • id — PK — Primary key — NOT NULL
  • Person_id — PK — Foreign key → Product.id — NOT NULL
  • Product_id — PK,AUTO_iNCREMENT — Foreign key → Person.id — NOT NULL

Person (Untitled)

  • id — PK,AUTO_iNCREMENT — Primary key — NOT NULL
  • user_id — unique, NOT NULL
  • password — NOT NULL
  • nickname — UNIQUE,NOT NULL

Product (Untitled3)

  • id — PK — Primary key — NOT NULL
  • company — NOT NULL
  • title
  • min_rate
  • max_limit