FISS_V2.0_hashtag

Tables (7)

HashTag (해시태그)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • is_active (Field) — BOOLEAN — NOT NULL
  • hash_tag_name (Field2) — VARCHAR(255) — NOT NULL — UNIQUE (중복 불가)
  • created_date (Field3) — DATETIME — NOT NULL
  • modified_date (Field4) — DATETIME — NOT NULL

Track (선로)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • start_facility_no (Key2) — Foreign key → facility.id — NOT NULL
  • end_facility_no (Key3) — Foreign key → facility.id — NOT NULL
  • track_length (1) — varchar(255) — NOT NULL
  • track_location (2) — NOT NULL — 지중/가공
  • track_type (3) — NOT NULL — 선로 종류
  • track_standard (4) — 코어 갯수
  • track_geometry (Field4) — NOT NULL
  • track_etc (Field5)
  • business_no (Field6)

UserHashTagMapping (사용자 해시태그 매핑)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
  • hash_tag_id (Key3) — BIGINT — Foreign key → HashTag.id — NOT NULL — UNIQUE(user_id, hash_tag_id) - 즐겨찾기/구독
  • created_date (Field) — DATETIME — NOT NULL
  • modified_date (Field2) — DATETIME — NOT NULL

Users (사용자)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

facility (시설물)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • facility_geometry (1) — NOT NULL — geo 포인트 객체
  • lat (2) — NOT NULL
  • lon (3) — NOT NULL — 경도
  • manage_no (4) — NOT NULL — fiss 상에서 실질적으로 쓰이는 시설물 명
  • business_no (5) — 비지니스 번호
  • nms_info_no (6) — 최초 설계시에 한 시설물에 하나의 스위치만 등록 가능하게 설계 되어서 만들어진 것 같음\
  • manage_name (7)
  • facility_nm (8) — NOT NULL
  • favorite_no (9) — BIGINT — 즐겨찾기 번호 같은데 테이블이 따로 있음
  • computerize_no (Field10)
  • content (Field11)
  • ip_no (Field12)
  • make_company (Field13)
  • main_poll_share_yn (Field14)
  • main_facility_no (Field18)
  • item_type (Field15)
  • drawing_id (Field16)
  • file (Field17)
  • lotno_addr (지번주소)

facility_hashtag (해시태그/시설물 매핑)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • facility_id (Key2) — BIGINT — Foreign key → facility.id — NOT NULL — UNIQUE(facility_id, hash_tag_id)
  • hash_tag_id (Key2) — BIGINT — Foreign key → HashTag.id — NOT NULL — UNIQUE(facility_id, hash_tag_id)
  • created_date (Field3) — DATETIME — NOT NULL
  • modified_date (Field4) — DATETIME — NOT NULL

track_hashtag (해시태그/선로 매핑)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • track_id (Key2) — BIGINT — Foreign key → Track.id — NOT NULL — UNIQUE(track_id, hash_tag_id)
  • hash_tag_id (Key3) — BIGINT — Foreign key → HashTag.id — NOT NULL — UNIQUE(track_id, hash_tag_id)
  • created_date (Field) — DATETIME — NOT NULL
  • modified_date (Field2) — DATETIME — NOT NULL