SSR2OSR
Tables (7)
code_master_tb (Untitled3)
- code_master_id (Key) — bigint — Primary key — NOT NULL
- code_explanation (Field2) — varchar(255) — NOT NULL — 코드 그룹 이름
code_tb (Untitled4)
- code_id (Key) — bigint — Primary key — NOT NULL
- code_master_id (Key2) — bigint — Foreign key → code_master_tb.code_master_id — NOT NULL
- code_value (Field2) — varchar(255) — NOT NULL — 코드 값
- code_name (Field3) — varchar(255) — NOT NULL — 코드 명
log_tb (Untitled6)
- log_id (Key) — bigint — Primary key — NOT NULL
- user_id (key) — bigint — Foreign key → user_tb.user_id — NOT NULL
- grid_point (Field) — varchar(10) — NOT NULL
- start_dt (Field2) — Date — NOT NULL
- end_dt (Field3) — Date — NOT NULL
- raw_cnt (Field4) — NOT NULL
mount_point_tb (Untitled5)
- mount_point_id (Key) — bigint — Primary key — NOT NULL
- mount_point (Field) — varhcar(30) — NOT NULL
- mount_point_name (Field2) — varchar(40) — NOT NULL
- host (Field3) — varchar(50) — NOT NULL
- address (Field4) — varchar(200) — NOT NULL
- igs_name (Field5) — varhcar(100) — NOT NULL
- serial_number (Field6) — varchar(255) — NOT NULL
- antenna_name (Field7) — varchar(100) — NOT NULL
- antenna_number (Field8) — varchar(50) — NOT NULL
- flag (Field9) — char — NOT NULL
- firmware_version (Field10) — varchar(100) — NOT NULL
- base_x (Field11) — double — NOT NULL
- base_y (Field12) — double — NOT NULL
- base_z (Field13) — double — NOT NULL
- port (Field14) — int — NOT NULL
server_err_log_tb (Untitled7)
- server_err_id (Key) — bigint — Primary key — NOT NULL
- err_code (Field) — varchar(50) — NOT NULL
- created_dt (Field2) — Date — NOT NULL
- server_type (Field3) — varchar(50) — NOT NULL
user_log_tb (Untitled2)
- user_log_id (Key) — bigint — Primary key — NOT NULL
- user_id (key) — bigint — Foreign key → user_tb.user_id — NOT NULL
- login_date (Field) — Date — NOT NULL
- ip (Field2) — varchar(50) — NOT NULL
- logout_date (Field3) — Date
- grid_point (Field4) — varchar(30) — NOT NULL
- raw_cnt (Field5) — bigint
user_tb (Untitled)
- user_id (key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(255) — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- user_name (Field5) — varchar(100) — NOT NULL
- current_refresh_token (Field3) — varchar(255)
- role (Field4) — varchar(100) — NOT NULL
- authority_level (Field6) — int — NOT NULL