asd
Tables (43)
ad_agency_client_t
- seq — serial4 — Primary key — NOT NULL
- company_cd — varchar(50)
- company_type_cd — varchar(10)
- ad_company_name — varchar(100)
- ad_company_corp_num — varchar(20)
- use_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
alembic_version
- version_num — varchar(32) — Primary key — NOT NULL
application_d
- app_seq — serial4 — Primary key — NOT NULL
- app_cate_cd — varchar(20)
- app_version — varchar(10)
- app_name — varchar(100)
- app_file_name — varchar(100)
- app_desc — varchar(1000)
application_m
- app_cate_cd — varchar(20) — Primary key — NOT NULL
- app_name — varchar(100)
- app_desc — varchar(1000)
card_d
- card_cd — varchar(20) — Primary key — NOT NULL
- view_num — int2 — Primary key — NOT NULL
- chain_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
card_m
- card_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20) — NOT NULL
- tile_layout_cd — varchar(20)
- content_name — varchar(1000)
- content_type — varchar(1)
- content_tag — _text
- ad_client_cd — int4
- ad_agency_cd — int4
- copyright — varchar(50)
- author — varchar(50)
- remark — text
- qr_url — varchar(100)
- qr_size — varchar(10)
- qr_position — varchar(10)
- use_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
code_t
- class_cd — varchar(10) — Primary key — NOT NULL
- code_cd — varchar(15) — Primary key — NOT NULL
- code_name — varchar(100)
- code_sort_num — int2
- use_yn — varchar(2)
- code_comment — varchar(200) — archar(200) NUL
- code_flag01 — varchar(100)
- code_flag02 — varchar(100)
- code_flag03 — varchar(100)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
command_item_d
- gubun — varchar(10) — Primary key — NOT NULL
- model_num — varchar(50) — Primary key — NOT NULL
- item_cd — varchar(25) — Primary key — NOT NULL
- s_command — varchar(20) — Primary key — NOT NULL
- item_option — varchar(20)
- command_desc — varchar(100)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
command_item_m
- gubun — varchar(10) — Primary key — NOT NULL
- item_cd — varchar(25) — Primary key — NOT NULL
- item_name — varchar(50)
- item_type — varchar(10)
- item_desc — varchar(100)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- column6 — varchar(50)
- column7 — varchar(50)
- column8 — varchar(50)
- column9 — varchar(50)
- column10 — varchar(50)
- column11 — varchar(50)
- column12 — varchar(50)
- column13 — varchar(50)
- column14 — varchar(50)
- column15 — varchar(50)
- column16 — varchar(50)
- column17 — varchar(50)
- column18 — varchar(50)
- column19 — varchar(50)
- column20 — varchar(50)
- column21 — varchar(50)
- column22 — varchar(50)
command_mng_t
- seq — serial4 — Primary key — NOT NULL
- gubun — varchar(10) — NOT NULL
- item — varchar(30) — NOT NULL
- item_option — varchar(30) — NOT NULL
- command — varchar(30) — NOT NULL
- command_desc — varchar(200)
- insert_date — timestamp
company_t
- company_cd — varchar(50) — Primary key — NOT NULL
- company_name — varchar(100)
- company_name_en — varchar(100)
- company_phone — varchar(50)
- corp_num — varchar(50)
- ceo_name — varchar(100)
- company_zip — varchar(10)
- company_base_addr — varchar(100)
- company_detail_addr — varchar(100)
- attache_file — varchar(100)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- user_count — int2
- company_logo — varchar(512)
- use_sensor — varchar(1)
- contract_start_date — date
- contract_end_date — date
- agreement_start_date — date
- agreement_end_date — date
content_t
- content_seq — serial4 — Primary key — NOT NULL
- card_cd — varchar(20) — NOT NULL
- view_num — int2 — NOT NULL
- item_num — int8
- item_sort — int2
- use_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
device_app_map
- device_cd — varchar(20) — Primary key — NOT NULL
- app_cate_cd — varchar(20) — Primary key — NOT NULL
- app_seq — int4
- update_app_seq — int4
device_command_setup_t
- device_cd — varchar(20) — Primary key — NOT NULL
- item_cd — varchar(25) — Primary key — NOT NULL
- s_command — varchar(20)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
device_m
- device_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20)
- ether_mac_address — varchar(50)
- wifi_mac_address — varchar(50)
- serial_num — varchar(50)
- device_model — varchar(50)
- device_state — varchar(10)
- cert_key — varchar(100)
- device_name — varchar(100)
- device_type — varchar(100)
- ktype_master_device_cd — varchar(20)
- operation_system — varchar(50)
- os_version — varchar(10)
- sensor_bd_model — varchar(50)
- volumn_yn — bpchar(1)
- volumn_size — int2
- display_type — varchar(10)
- schedule_use_yn — bpchar(1)
- display_resolution_x — varchar(50)
- display_resolution_y — varchar(50)
- display_rate — varchar(50)
- x_coordinate — varchar(100)
- y_coordinate — varchar(100)
- remark — text
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- backlight_on — varchar(10)
- backlight_off — varchar(10)
- display_rotation — int4
- total_storage — int8
- used_storage — int8
- ktype_content_text — varchar(150)
device_tile_t
- tile_cd — varchar(20) — Primary key — NOT NULL
- device_cd — varchar(20)
- tile_num — varchar(50)
- sirial_num — varchar(50)
- device_state — varchar(10)
- volumn_yn — bpchar(1)
- display_type — varchar(10)
- x_coodinate — varchar(10)
- y_coodinate — varchar(10)
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
disability_t
- id — int4 — Primary key — NOT NULL
- reg_date — varchar(8) — NOT NULL
- dis_type — bpchar(1) — NOT NULL
- company_cd — varchar(20) — NOT NULL
- media_cd — varchar(20) — NOT NULL
- device_cd — varchar(20) — NOT NULL
- dis_detail — varchar(500)
- act_type — varchar(1)
- act_date — varchar(8) — NOT NULL
- act_detail — text
- cause — varchar(500)
- ref_data — bytea
- notes — varchar(500)
- ins_date — timestamp — NOT NULL
email_verify_key
- key — varchar(64) — Primary key — NOT NULL
- insert_date — timestamptz — NOT NULL
- email — varchar(100) — NOT NULL
- expired — timestamptz
- is_verified — bool — NOT NULL
item_element_t
- item_num — serial4 — Primary key — NOT NULL
- company_cd — varchar(20) — NOT NULL
- item_type — varchar(2)
- item_tag — _text
- file_url — varchar(100)
- replace_img — varchar(100)
- file_name — varchar(50)
- original_file_name — varchar(100)
- play_time — int4
- resolution_x — varchar(10)
- resolution_y — varchar(10)
- file_size — int8
- file_path — varchar(100)
- preservation_period — varchar(8)
- snap_shot_file — text
- ad_client_cd — int4
- ad_agency_cd — int4
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
log_device_event
- seq — int4 — Primary key — NOT NULL
- device_cd — varchar(20) — NOT NULL
- code_cd — varchar(10) — NOT NULL
- event_timestamp — timestamptz
- value — varchar(20)
- etc02 — varchar(10)
- insert_date — timestamptz
log_device_event_t
- seq — serial4 — Primary key — NOT NULL
- yyyy_mm — varchar(6) — NOT NULL
- device_cd — varchar(20) — NOT NULL
- log_type — varchar(10)
- log_level — varchar(10)
- item_cd — varchar(25)
- s_command — varchar(20)
- option_val — varchar(20)
- return_val — varchar(200)
- event_date — varchar(20)
- event_time — varchar(20)
- insert_date — timestamptz
log_player
- seq — serial4 — Primary key — NOT NULL
- device_cd — varchar(20) — NOT NULL
- log_type — varchar(20)
- log_level — varchar(20)
- event_name — varchar(20)
- item_num — int4
- start_date — timestamptz
- end_date — timestamptz
- status — varchar(10)
- log_text — varchar(1200)
- insert_date — timestamptz
media_group_m
- media_group_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20)
- media_group_name — varchar(200)
- media_group_type — varchar(10)
- power_control_type — varchar(2)
- power_on — varchar(6)
- power_off — varchar(6)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- business_slot_cnt — int2
- slot_play_time — int4
- play_cnt — int4
- operate_from_time — varchar(16)
- operate_to_time — varchar(16)
- commercial_fee — int4
- media_group_tag — _text
- media_list — _text
- commercial_period — varchar(32)
- use_yn — varchar(1)
- operate_day — _text
- 7::text — NULL
media_m
- media_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20)
- media_name — varchar(200)
- media_width — varchar(10)
- media_height — varchar(10)
- media_size — varchar(10)
- x_coordinate — varchar(20)
- y_coordinate — varchar(20)
- zip — varchar(10)
- base_address — varchar(100)
- detail_address — varchar(100)
- media_type — varchar(10)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- media_category — varchar(32)
- media_place_site — varchar(64)
- media_tag — _text
- media_install_file — varchar(256)
- media_orientation — varchar(20)
- led_pitch — numeric(4, 2)
media_map
- upper_cd — varchar(20) — Primary key — NOT NULL
- lower_cd — varchar(20) — Primary key — NOT NULL
- order_num — int2
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
media_site_m
- media_site_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20)
- media_site_name — varchar(200)
- location_1 — varchar(20)
- location_2 — varchar(20)
- public_slot_cnt — int2
- business_slot_cnt — int2
- slot_play_time — int2
- operate_type — varchar(10)
- operate_from_time — varchar(6)
- operate_to_time — varchar(6)
- play_cnt — int2
- media_facet_num — int2
- commercial_fee — int4
- commercial_period — varchar
- remark — text
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
public_token_mng_t
- token_origin — varchar(20) — Primary key — NOT NULL
- token_name — varchar(20) — Primary key — NOT NULL
- token_id — varchar(500) — NOT NULL
- refresh_token_id — varchar(500)
- issued_date — timestamptz
- expire_date — timestamptz
- retkn_expire_date — timestamp
- insert_date — timestamptz
schedule_composition_d
- schedule_date — varchar(8) — Primary key — NOT NULL
- media_group_cd — varchar(20) — Primary key — NOT NULL
- schedule_cd — varchar(20) — Primary key — NOT NULL
- device_cd — varchar(20) — Primary key — NOT NULL
- card_cd — varchar(20)
- sync_yn — bpchar(1)
- content_type — bpchar(1)
- play_time — int4
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
schedule_composition_m
- schedule_date — varchar(8) — Primary key — NOT NULL
- media_group_cd — varchar(20) — Primary key — NOT NULL
- schedule_cd — varchar(20) — Primary key — NOT NULL
- tray_cd — varchar(20)
- sort_num — int2
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
schedule_map
- schedule_cd — varchar(20) — Primary key — NOT NULL
- media_group_cd — varchar(20) — Primary key — NOT NULL
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
schedule_t
- schedule_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20) — NOT NULL
- schedule_name — varchar(50)
- schedule_from — varchar(8)
- schedule_to — varchar(8)
- schedule_tag — _text
- schedule_type — bpchar(2)
- display_type — bpchar(2)
- schedule_order_num — int2
- tray_cd — varchar(20)
- fix_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- use_yn — varchar(1)
- stop_reason — varchar(50)
- stop_yn — varchar(1)
- pre_roll_content — varchar(20)
- schedule_time_from — time
- schedule_time_to — time
- time_operate_option — varchar(20)
- time_seconds — int4
- play_count — int4
screen_shot_img_t
- seq — serial4 — Primary key — NOT NULL
- device_cd — varchar(20)
- schedule_cd — varchar(20)
- item_num — int8
- img_file_name — varchar(100)
- res_date — timestamptz
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
sensorbd_info_t
- device_cd — varchar(20) — NOT NULL
- item — varchar(30) — NOT NULL
- item_option — int8 — NOT NULL
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
store_dev_m
- id — serial4 — Primary key — NOT NULL
- serial_no — varchar(50) — NOT NULL
- supply_cd — varchar(1) — NOT NULL
- model_name — varchar(50) — NOT NULL
- device_class — varchar(1) — NOT NULL
- use_yn — varchar(10)
- rcv_date — timestamp
- reg_date — timestamp
- upd_date — timestamp
tile_layout_d
- tile_layout_cd — varchar(20) — Primary key — NOT NULL
- view_num — int2 — Primary key — NOT NULL
- view_resolution_x — varchar(10)
- view_resolution_y — varchar(10)
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
tile_layout_m
- tile_layout_cd — varchar(20) — Primary key — NOT NULL
- layout_resolution_x — varchar(10)
- layout_resolution_y — varchar(10)
- view_qty — int2
- insert_date — timestamp
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamp
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
token_issue_t
- refresh_token — varchar(2000) — Primary key — NOT NULL
- access_token — varchar(2000) — NOT NULL
- user_email — varchar(100) — NOT NULL
tray_content_d
- seq — serial4 — Primary key — NOT NULL
- tray_cd — varchar(20) — NOT NULL
- card_cd — varchar(20)
- card_sort_num — int2
- use_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
tray_content_m
- tray_cd — varchar(20) — Primary key — NOT NULL
- company_cd — varchar(20) — NOT NULL
- content_type — varchar(1)
- sync_yn — bpchar(1)
- sync_name — varchar(100)
- play_time — int4
- exposure_card_cd — varchar(20)
- ad_client_cd — int4
- ad_agency_cd — int4
- use_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
user_auth_t
- user_auth — varchar(20) — Primary key — NOT NULL
- auth_name — varchar(200) — NOT NULL
- user_role — _varchar
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
user_login_history_t
- seq — serial4 — Primary key — NOT NULL
- user_email — varchar(100) — NOT NULL
- gubun — varchar(20) — NOT NULL
- access_token — varchar(2000) — NOT NULL
- refresh_token — varchar(2000) — NOT NULL
- insert_date — timestamptz
user_role_t
- user_role — varchar(20) — Primary key — NOT NULL
- role_name — varchar(200) — NOT NULL
- role_desc — varchar(1000) — NOT NULL
user_t
- user_cd — varchar(20) — Primary key — NOT NULL
- user_name — varchar(100) — NOT NULL
- user_password — varchar(1000) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_cate — varchar(10)
- company_cd — varchar(50)
- main_charge_yn — bpchar(1)
- user_position — varchar(50)
- user_phone — varchar(20)
- user_auth — varchar(20)
- activ_yn — bpchar(1)
- insert_date — timestamptz
- insert_user_cd — varchar(20)
- insert_ip — varchar(40)
- modify_date — timestamptz
- modify_user_cd — varchar(20)
- modify_ip — varchar(40)
- user_department — varchar(64)
- user_company_phone — varchar(16)