AWG5208

Tables (6)

awg_common

  • id — bigserial — Primary key — NOT NULL — auto increment
  • locale — varchar
  • carrier_power — decimal
  • frequency — decimal
  • bandwidth — decimal

awg_config_file

  • id — bigserial — Primary key — NOT NULL — auto increment
  • file_name — varchar — NOT NULL
  • description — text

awg_config_file_history

  • id — bigserial — Primary key — NOT NULL — auto increment
  • file_id — bigint — NOT NULL

awg_frame

  • id — VARCHAR(255) — Primary key — NOT NULL — auto increment
  • frame_name — varchar — NOT NULL
  • is_preamble_enabled — boolean
  • is_header_enabled — boolean
  • is_payload_enabled — boolean
  • is_frame_spacing_enabled — boolean
  • frame_spacing — varchar
  • header_type — varchar — file, symbols 택 1
  • header_info — jsonb
  • payload_info — jsonb

awg_setting

  • id — bigserial — Primary key — NOT NULL — auto increment
  • symbol_id — bigint — Foreign key → awg_symbol.id — NOT NULL — auto increment
  • frame_id — bigint — Foreign key → awg_frame.id — NOT NULL — auto increment
  • common_id — bigint — Foreign key → awg_common.id — NOT NULL — auto increment

awg_symbol

  • id — bigserial — Primary key — NOT NULL — auto increment
  • symbol_name — varchar(20) — NOT NULL
  • config_file_enabled — boolean — NOT NULL
  • config_file_name — varchar — NOT NULL — Config 파일 사용 true일 때 NOT NULL
  • subcarrier_spacing — decimal
  • total_subcarrier — decimal
  • null_position_enabled — boolean
  • null_position — TEXT
  • guard_position_enabled — boolean
  • guard_position — TEXT
  • is_data_enabled — boolean
  • data_pattern — TEXT
  • data_modulation_type — varchar
  • data_modulation_qam — TEXT — NOT NULL — Data Modulation Type QAM일 때 NOT NULL
  • data_modulation_psk — TEXT — NOT NULL — Data Modulation Type PSK일 때 NOT NULL
  • data_positions — TEXT
  • is_pilot_enabled — boolean
  • pilot_pattern — TEXT
  • pilot_modulation_type — varchar
  • pilot_modulation_qam — TEXT
  • pilot_modulation_psk — TEXT
  • pilot_positions — TEXT
  • is_frequency_offset_enabled — boolean
  • frequency_offset — TEXT
  • is_phase_offset_enabled — boolean
  • phase_offset — TEXT
  • is_clipping_ratio_enabled — boolean
  • clipping_ratio — TEXT
  • is_guard_interval_enabled — boolean
  • guard_interval — TEXT
  • guard_interval_option — smallint — 0 - Cyclic prefix, 1- Zero padding
  • is_amplitude_enabled — boolean
  • amplitude_type — smallint — Fixed 선택 여부
  • is_amplitude_data_enabled — boolean
  • amplitude_data_amplitude — varchar
  • amplitude_data_phase — VARCHAR(255)
  • amplitude_custom — JSONB — Custom Amplitude 행
  • null_carrier — varchar
  • guard_carrier — varchar
  • data_carrier — varchar
  • pilot_carrier — varchar