GSIM new
테이블 (6)
Files (tb_it_file)
- ID (project_id) — varchar(255) — 외래 키 → 프로젝트와 모델.ID — NOT NULL
- File Path (file_path) — varchar
- File Classification (file_cals) — varchar
- Memo (memo) — varchar
Geometry Type (tb_it_geom_type)
- ID (geom_type_id) — int — 기본 키 — NOT NULL
- Type Name (geom_type_nm) — varchar(40)
사용자 계정 (tb_it_user)
- ID (user_id) — varchar(255) — 기본 키 — NOT NULL
- Password (pw) — varchar(255)
- Name (nm) — varchar(40)
- Company (company) — varchar(40)
- Phone Number (phone_no) — varchar(20)
- E-mail (email) — varchar(255)
- Role Level (level) — int
- Memo (memo) — varchar
- Regist Date (regist_dt) — timestamp
- Last Login Date (last_dt) — timestamp
- Deleted YN (is_deleted) — bool
- Issue Count (issue_cnt) — int
스테이지 (tb_it_stage)
- ID (stage_id) — int — 기본 키 — NOT NULL
- Name (stage_nm) — varchar(255)
잡다한 테이블 (tb_it_issue)
- ID (issue_id) — varchar(255) — 기본 키 — NOT NULL
- User ID (user_id) — varchar(255) — 외래 키 → 사용자 계정.ID — NOT NULL
- Project ID (project_id) — varchar(255) — 외래 키 → 프로젝트와 모델.ID — NOT NULL
- Geometry Type ID (geom_type_id) — int — 외래 키 → Geometry Type.ID — NOT NULL
- Create date (create_dt) — timestamp
- Title (title) — varchar(40)
- Content (content) — varchar
- Deleted YN (is_deleted) — bool
- Font Size (font_size) — int
- Color (color) — varchar(20)
- Properties (geom_prop) — varchar
- Geometry (geom) — varchar
프로젝트와 모델 (tb_it_project)
- ID (project_id) — varchar(255) — 기본 키 — NOT NULL
- ID (stage_id) — int — 외래 키 → 스테이지.ID — NOT NULL
- Name (nm) — varchar(40)
- Create Date (create_dt) — timestamp
- Parent ID (parent_id) — varchar(255) — NOT NULL
- Depth (depth) — int
- Location Point (geom) — varchar