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