보안
테이블 (7)
sno_security_brand (스노방 보안 업체명)
- seq (Key) — INT — 기본 키 — NOT NULL
- brand_code (Field3) — CHAR
- brand_name (Field) — VARCHAR
- is_use (Field2) — TINYINT
sno_security_discount (스노방 보안 할인)
- seq (Key) — INT — 기본 키 — NOT NULL
- discount_product_code (Key2) — CHAR — 외래 키 → sno_security_product_big.seq — NOT NULL
- combination_product_code (Key22) — CHAR — 외래 키 → sno_security_product_big.brand_seq — NOT NULL
- discount_price (Field) — INT
- is_use (Field2) — TINYINT
sno_security_product_big (스노방 보안 제품명(대분류))
- seq (Key) — INT — 기본 키 — NOT NULL
- brand_seq (Key2) — INT — 외래 키 → sno_security_brand.seq — NOT NULL
- product_code (Field) — CHAR
- product_big_name (Field2) — VARCHAR
- is_use (Field3) — TINYINT
sno_security_product_small (스노방 보안 제품명(소분류))
- seq (Key) — INT — 기본 키 — NOT NULL
- product_big_seq (Key2) — INT — 외래 키 → sno_security_product_big.seq — NOT NULL
- product_small_code (Field2) — CHAR
- product_small_name (Field3) — VARCHAR
- price (Field) — INT
- is_use (Field4) — TINYINT
sno_security_service (스노방 보안 부가서비스)
- seq (Key) — INT — 기본 키 — NOT NULL
- product_small_seq (Key2) — INT — 외래 키 → sno_security_product_small.seq — NOT NULL
- service_code (Field) — VAR
- service_name (Field3) — VARCHAR
- is_type (Field2) — TINYINT
- is_use (Field4) — TINYINT
sno_security_service_type_qty (스노방 보안 부가서비스 수량)
- seq (Key) — INT — 기본 키 — NOT NULL
- service_seq (Key2) — INT — 외래 키 → sno_security_service.seq — NOT NULL
- service_qty_code (Field) — CHAR
- service_qty_name (Field2) — VARCHAR
- plus_qty (Field3) — INT
- min_qty (Field4) — INT
- max_qty (Field5) — INT
- dafault_price (Field6) — INT
- addition_price (Field7) — INT
- is_use (Field8) — TINYINT
sno_security_service_type_select (스노방 보안 부가서비스 조건 셀렉트박스)
- seq (Key) — INT — 기본 키 — NOT NULL
- service_seq (Key2) — INT — 외래 키 → sno_security_service.seq — NOT NULL
- service_select_code (Field4) — CHAR
- service_select_name (Field) — VARCHAR
- price (Field2) — INT
- amends_price (Field3) — VARCHAR
- is_use (Field5) — TINYINT