fick

Tables (4)

crack (Crack)

  • structure_id (id) — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • created_date (createdDate) — datetime
  • modified_date (modifiedDate) — datetime
  • comment — text
  • height — double
  • is_crack (isCrack) — tinyint(1)
  • location_detail (locationDetail) — varchar(255)
  • locationx (locationX) — double
  • locationy (locationY) — double
  • photo_url (photoUrl) — text
  • width — double

project (Project)

  • project_id (id) — b igint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_date (createdDate) — datetime — NOT NULL
  • modified_date (modifiedDate) — datetime — NOT NULL
  • comment — text
  • location_detail (locationDetail) — varchar(255)
  • locationx (locationX) — double
  • locationy (locationY) — double
  • photo_url (photoUrl) — text — NOT NULL
  • structure_id (id2) — bigint(20) — Foreign key → structure.structure_id — NOT NULL

structure (Structure)

  • structure_id (id) — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • created_date (createdDate) — datetime
  • modified_date (modifiedDate) — datetime
  • comment — text
  • height — double
  • is_work_done (isWorkDone) — tinyint(1)
  • location_detail (locationDetail) — varchar(255)
  • locationx (locationX) — double
  • locationy (locationY) — double
  • model_url (modelUrl) — text
  • structure_id (id2) — bigint(20) — Foreign key → crack.structure_id — NOT NULL

user (User)

  • user_id (id) — b igint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_date (createdDate) — datetime — NOT NULL
  • modified_date (modifiedDate) — datetime — NOT NULL
  • UID — int — NOT NULL
  • project_id (id2) — b igint(20) — Foreign key → project.project_id — NOT NULL