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