crawling

Tables (4)

crawling_log (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → user.id — NOT NULL
  • product_id (Key3) — long — Foreign key → product.id — NOT NULL
  • state (Field) — text
  • status (Field2) — int
  • updated (Field3) — DATE(6)
  • created (Field4) — DATE(6)

product (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — varchar(11)
  • price (Field2) — int(11)
  • useable (Field5) — int
  • updated (Field3) — DATE(6)
  • created (Field4) — DATE(6)

purchase (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → user.id — NOT NULL
  • product_id (Key3) — long — Foreign key → product.id — NOT NULL
  • expiration_period (Field3) — int
  • status (Field) — varchar(11)
  • updated (Field2) — DATE(6)
  • created (Field4) — DATE(6)

user (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — varchar(11)
  • birth (Field2) — varchar(11)
  • phone (Field3) — varchar(11)
  • email (Field4) — varchar(255)
  • gender — varchar(11)
  • nickname (Field6) — varchar(11)
  • password (Field7) — varchar(255)
  • verified_email (Field8) — int(1)
  • updated (nullable) — DATE(6)
  • created (Field5) — DATE(6)