ㅁㅇㄴㄹ

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)