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)