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) — 행위자