ㅁㅇㄴㄹ
Tables (8)
board_comment
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- content — tinytext — NOT NULL
- edited — bit — NOT NULL
- created_by_email — varchar(255)
- deleted_by_email — varchar(255)
- updated_by_email — varchar(255)
- author_email — varchar(255) — NOT NULL
- post_id — bigint — NOT NULL
board_post
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- content — tinytext — NOT NULL
- image_url — varchar(500) — 게시글 대표 이미지 URL
- title — varchar(200) — NOT NULL
- type — enum — NOT NULL
- view_count — bigint — NOT NULL — 조회수
- created_by_email — varchar(255)
- deleted_by_email — varchar(255)
- updated_by_email — varchar(255)
- author_email — varchar(255) — NOT NULL
camera
- id — bigint — Primary key — NOT NULL
- image_description — varchar(255)
- image_url — varchar(255)
- ip — varchar(255)
- latitude — float(23)
- location — varchar(255)
- longitude — float(23)
- create_date — datetime(6) — NOT NULL
inspection_setting
- id — bigint — Primary key — NOT NULL
- inspection_cycle — integer
- last_inspected_date — datetime(6)
- start_date — varchar(255)
- start_time — varchar(255)
issue
- id — bigint — Primary key — NOT NULL
- creation_date — datetime(6)
- estimate — bigint
- estimate_basis — varchar(2000)
- is_processing — bit — NOT NULL
- status — enum
- type — enum
- vision_analysis — varchar(500)
- inspection_id — bigint
- public_fa_id — bigint
public_fa
- id — bigint — Primary key — NOT NULL
- image_description — varchar(255)
- image_url — varchar(255)
- install_date — datetime(6)
- last_repair — datetime(6)
- obstruction — varchar(255)
- obstruction_basis — varchar(255)
- section_height — float(53) — NOT NULL
- section_width — float(53) — NOT NULL
- section_x_center — float(53) — NOT NULL
- section_y_center — float(53) — NOT NULL
- status — enum
- type — enum
- camera_id — bigint
report
- creation_date — datetime(6) — Primary key — NOT NULL
- content_description — varchar(255)
- content_url — varchar(255)
- inspection_id — bigint
- creation_date — datetime(6)
- file_description — varchar(255)
- file_url — varchar(255)
- issue_id — bigint
users
- email — varchar(255) — Primary key — NOT NULL
- approval_status — enum
- department — enum
- level — bigint
- password — varchar(255)
- type — enum
- username — varchar(255)