보안

테이블 (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