POSI PMI
Tables (22)
ad_group
- created_at — timestamp(6)
- updated_at — timestamp(6)
- ad_group_name — varchar(100) — NOT NULL — 광고그룹
- transition_type — varchar(100) — NOT NULL — 전환
- SLIDE_UP::character — varying
- SLIDE_DOWN::character — varying
- SLIDE_LEFT::character — varying
- SLIDE_RIGHT::character — varying
- SLIDE_DISSOLVE::character — varying
- CENTER_MASK::character — varying)::text))
- ad_group_id — varchar(255) — NOT NULL — 광고그룹
- created_by — varchar(255)
- memo — varchar(255) — 메모
- updated_by — varchar(255)
ad_group_resource
- height — integer — 해상도
- play_time — integer — NOT NULL — 광고
- sort_order — integer — NOT NULL — 정렬
- width — integer — 해상도
- created_at — timestamp(6)
- updated_at — timestamp(6)
- ad_title — varchar(100) — NOT NULL — 광고안
- ad_group_id — varchar(255) — NOT NULL
- ad_resource_id — varchar(255) — 광고안
- file_path — varchar(255) — 파일
ad_health_logs
- created_at — timestamp(6) — 생성일
- id — bigint
- ad_type — varchar(255) — 광고안
- mac_address — varchar(255) — MAC
ad_playback_logs
- created_at — timestamp(6) — 생성일
- id — bigint
- play_time — bigint — 재생
- ad_resource_id — varchar(255) — 광고안
- mac_address — varchar(255) — MAC
ad_resource
- height — integer — NOT NULL — 해상도
- play_time — integer — NOT NULL — 재생
- width — integer — NOT NULL — 해상도
- created_at — timestamp(6)
- file_size — bigint — NOT NULL — 파일
- updated_at — timestamp(6)
- ad_title — varchar(100) — NOT NULL — 광고안
- file_path — varchar(100) — NOT NULL — 파일
- ad_resource_id — varchar(255) — NOT NULL — 광고안
- created_by — varchar(255)
- file_name — varchar(255) — NOT NULL — 광고
- memo — varchar(255) — 메모
- updated_by — varchar(255)
apk
- created_at — timestamp(6)
- updated_at — timestamp(6)
- apk_id — varchar(255) — NOT NULL
- created_by — varchar(255)
- model_name — varchar(255)
- updated_by — varchar(255)
apk_file
- apk_file_size — bigint — APK
- created_at — timestamp(6)
- updated_at — timestamp(6)
- apk_file_name — varchar(255) — NOT NULL — APK
- apk_file_path — varchar(255) — NOT NULL — APK
- apk_id — varchar(255) — NOT NULL
- memo — varchar(255) — APK
- version — varchar(255) — NOT NULL — APK
bj_dong
- created_at — timestamp(6)
- updated_at — timestamp(6)
- dong_code — varchar(255) — NOT NULL — 동
- dong_name — varchar(255) — 동
- dong_type — varchar(255) — 동
- SI_GUN_GU::character — varying
- DONG::character — varying)::text))
- parent_id — varchar(255) — 상위
client_code
- code — varchar(255) — NOT NULL
- description — varchar(255) — 클라이언트
- name — varchar(255) — 클라이언트
connection_log
- connected_at — timestamp(6) — 접속
- log_id — bigint
- action_type — varchar(255) — 액션
- APK_UPDATE::character — varying
- DOWNLOAD_AD_INFO::character — varying)::text))
- ip_address — varchar(255)
- mac_address — varchar(255) — MAC
device
- brightness — integer — NOT NULL — 디바이스
- client_code — varchar(2) — NOT NULL — 시리얼번호
- model_code — varchar(2) — NOT NULL
- production_month — varchar(2) — NOT NULL
- production_year — varchar(2) — NOT NULL
- sequence_number — varchar(4) — NOT NULL
- created_at — timestamp(6)
- schedule_end_datetime — timestamp(6) — 스케줄
- schedule_start_datetime — timestamp(6) — 스케줄
- updated_at — timestamp(6)
- product_code — varchar(10) — NOT NULL
- mac_address — varchar(17) — NOT NULL
- serial_number — varchar(20)
- created_by — varchar(255)
- default_ad_group_id — varchar(255)
- device_id — varchar(255) — NOT NULL — 디바이스
- event_ad_resource_id — varchar(255)
- memo — varchar(255) — 메모
- power — varchar(255) — 디바이스
- OFF::character — varying)::text))
- schedule_ad_group_id — varchar(255) — 스케줄
- schedule_days — varchar(255) — 실행
- schedule_play_end_time — varchar(255) — 종료시간:
- schedule_play_start_time — varchar(255) — 시작시간:
- updated_by — varchar(255)
device_command
- is_executed — boolean
- created_at — timestamp(6)
- updated_at — timestamp(6)
- command — varchar(255) — 명령어
- device_id — varchar(255) — NOT NULL
free_set
- resolution_height — integer — 해상도
- resolution_ratio — double — 해상도
- resolution_width — integer — 해상도
- created_at — timestamp(6)
- updated_at — timestamp(6)
- client_id — varchar(255) — 클라이언트
- freeset_id — varchar(255) — NOT NULL
- memo — varchar(255) — 메모
model_code
- code — varchar(255) — NOT NULL
- description — varchar(255) — 설명
- name — varchar(255) — 이름
modem
- created_at — timestamp(6)
- updated_at — timestamp(6)
- created_by — varchar(255)
- memo — varchar(255) — 메모
- modem_id — varchar(255) — NOT NULL — 모뎀
- name — varchar(255) — NOT NULL — 모뎀명
- serial_number — varchar(255) — NOT NULL — 시리얼
- updated_by — varchar(255)
product_code
- code — varchar(255) — NOT NULL
- description — varchar(255) — 설명
- name — varchar(255) — 이름
serial_number_sequence
- client_code — varchar(2) — NOT NULL
- last_sequence — integer — NOT NULL
- model_code — varchar(2) — NOT NULL
- product_code — varchar(1) — NOT NULL
- production_month — varchar(2) — NOT NULL
- production_year — varchar(2) — NOT NULL
- id — bigint
store
- post_code — varchar(5) — 우편번호
- created_at — timestamp(6)
- updated_at — timestamp(6)
- bcode — varchar(10) — 법정동
- base_address — varchar(200) — 주소
- detail_address — varchar(200) — 상세
- created_by — varchar(255)
- memo — varchar(255) — 메모
- store_id — varchar(255) — NOT NULL — 점포
- store_name — varchar(255) — 점포
- updated_by — varchar(255)
store_device
- created_at — timestamp(6)
- updated_at — timestamp(6)
- device_id — varchar(255)
- store_id — varchar(255) — NOT NULL
store_modem
- modem_id — varchar(255)
- store_id — varchar(255) — NOT NULL
user
- created_at — timestamp(6)
- updated_at — timestamp(6)
- password — varchar(255) — NOT NULL — 비밀번호
- phone_number — varchar(255) — NOT NULL — 전화번호
- role_group — varchar(255) — NOT NULL — 권한
- MEMBER::character — varying
- CLIENT::character — varying)::text))
- user_id — varchar(255) — NOT NULL — 사용자
- username — varchar(255) — NOT NULL — 사용자명
user_action_logs
- created_at — timestamp(6) — 생성일시
- id — bigint
- action — varchar(255) — 행위
- UPDATE::character — varying
- DELETE::character — varying)::text))
- browser — varchar(255) — 브라우저
- description — varchar(255) — 설명
- ip_address — varchar(255) — 사용자
- menu — varchar(255) — 메뉴
- DEVICE::character — varying
- AD_GROUP::character — varying
- AD_RESOURCE::character — varying
- APK::character — varying
- MODEM::character — varying
- USER::character — varying)::text))
- os — varchar(255) — 운영체제
- target_id — varchar(255) — 대상
- user_id — varchar(255) — 행위자