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