public_insu
Tables (16)
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_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)