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