test

Tables (7)

event_sms_permission

  • uid (Key) — integer — Primary key — NOT NULL
  • gid — integer
  • smartcity — boolean
  • fire_alarm — boolean
  • embell — boolean
  • its — boolean

group

  • gid — bigserial — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • dashboard — boolean — NOT NULL
  • monitoring — boolean — NOT NULL
  • statistics — boolean — NOT NULL
  • management — boolean — NOT NULL
  • reg_date — timestamp
  • reg_ip — varchar(15)
  • reg_member — varchar(20)
  • mod_date — timestamp
  • mod_ip — varchar(15)
  • mod_member — varchar(20)
  • del_date — timestamp
  • del_ip — varchar(15)
  • del_member — varchar(20)
  • event_yn — boolean
  • twin — boolean

group_event_sms_message (Untitled)

    promotion_object

    • ID (id) — BIGINT — Primary key — NOT NULL
    • 타입 (type) — VARCHAR(20) — NOT NULL
    • 작성자 (user_name) — VARCHAR(30) — NOT NULL
    • 생성시간 (created_date) — DATETIME — NOT NULL
    • 수정시간 (updated_date) — DATETIME
    • 코멘트 (comment) — TEXT

    promotion_zone

    • 번호 (id) — BIGINT — Primary key — NOT NULL
    • 디스플레이 ID (display_id) — BIGINT — Foreign key → promotion_object.ID — NOT NULL

    sms_safety_info_msg

    • uid — bigserial — Primary key — NOT NULL
    • topic — varchar — NOT NULL
    • subject — varchar — NOT NULL
    • content — varchar — NOT NULL
    • use_yn — boolean — NOT NULL
    • reg_date — timestamp — NOT NULL
    • reg_ip — varchar(15)
    • reg_member — varchar(20)
    • mod_date — timestamp
    • mod_ip — varchar(15)
    • mod_member — varchar(20)

    zone_files

    • 번호 (id) — BIGINT — Primary key — NOT NULL
    • 제목 (title) — VARCHAR(500) — NOT NULL
    • 원본 제목 (original_title) — VARCHAR(50) — NOT NULL
    • 경로 (path) — TEXT — NOT NULL
    • 업로드 시간 (upload_date) — DATETIME — NOT NULL
    • 타입 (type) — VARCHAR(20) — NOT NULL
    • 크기 (size) — BIGINT — NOT NULL
    • 순서 (order) — INTEGER — NOT NULL
    • zone 번호 (zone_id) — BIGINT — Foreign key → promotion_zone.번호 — NOT NULL