public_insu

Tables (16)

ADMIN_LOG_TB (admin_log)

    ADMIN_MASTER_TB (admin_master)

    • ADMIN_SQ — int — Primary key — NOT NULL
    • DISTRICT_SQ — int
    • ADMIN_GRADE_SQ — int
    • Field3
    • Field4

    AGREE_MASTER_TB (Untitled)

      COMMON_BUSINESS_TB (common_business)

      • BUSINESS_SQ — int — Primary key — NOT NULL
      • TYPE_TXT — varchar(50) — NOT NULL — 업태(대분류)
      • CODE_NO — int — NOT NULL — 코드번호(종목에 따른 코드번호)
      • CATEGORY_TXT — varchar(50) — NOT NULL — 종목(세분류)
      • CATE_DETAIL_TXT — varchar(50) — NOT NULL — 세세분류
      • Field

      COMMON_CODEBOOK_TB (common_codebook)

        COMMON_DISTRICT_TB (common_district)

        • DISTRICT_SQ — int — Primary key — NOT NULL
        • DISTRICT_A_TXT — varchar(20) — NOT NULL — 최상위 행정구역 1. 특별시, 광역시, 도 (16개) - 서울특별시 - 인천광역시, 대전광역시, 대구광역시, 부산광역시, 울산광역시, 광주광역시 - 경기도, 전라남북도,충청남북도, 경상남북도, 강원도, 제주도
        • DISTRICT_B_TXT — varchar(20) — NOT NULL — 군, 구청
        • DISTRICT_C_TXT — varchar(20) — NOT NULL — 하위 행정구역(읍,면,동,리)

        COMMON_GRADE_TB (common_grade)

        • GRADE_SQ — int — Primary key — NOT NULL
        • Field
        • Field2
        • Field3
        • Field4
        • Field5

        GUEST_LOG_TB (guest_log)

        • GUEST_SQ — int — Primary key — NOT NULL
        • LOGTYPE_CD — varchar(20)
        • FIELD_CD — varchar(20)
        • PREDATA_TXT — varchar(255)
        • IP_TXT — varchar(40)
        • DEVICE_CD — varchar(20)
        • PAGEURL_TXT — varchar(255)
        • REG_DT — datetime

        GUEST_MASTER_TB (guest_master)

        • GUEST_SQ — int — Primary key — NOT NULL
        • DISTRICT_SQ — int — Foreign key → COMMON_DISTRICT_TB.DISTRICT_SQ — NOT NULL
        • BUSINESS_SQ — int — Foreign key → COMMON_BUSINESS_TB.BUSINESS_SQ — NOT NULL
        • GUEST_NM — varchar(20)
        • GUEST_EN_NM — varchar(50)
        • OWNER_NM — varchar(20)
        • BUSINUM_TXT — varchar(20)
        • EMAIL_TXT — varchar(30)
        • PHONE_TXT — varchar(20)
        • FAX_TXT — varchar(15)
        • WEBURL_TXT — varchar(50)
        • POSTNUM_TXT — varchar(7)
        • ADDRESS_TXT — varchar(100)
        • Field9
        • Field10
        • Field11
        • GUEST_SQ (GUEST_SQ2) — int — Foreign key → GUEST_LOG_TB.GUEST_SQ — NOT NULL

        ORDER_LOG_TB (order_log)

          ORDER_MASTER_TB (order_master)

            PAYMENT_KCP_TB (payment_kcp)

              PAYMENT_LOG_TB (payment_log)

                PAYMENT_MASTER_TB (payment_master)

                  PLAN_MASTER_TB (plan_master)

                    WONSA_MASTER_TB (wonsa_master)