애견샾
테이블 (7)
RATE
- CORP — VARCHAR2(5 BYTE) — 기본 키 — NOT NULL
- RATE_CODE — VARCHAR2(4 BYTE) — 기본 키 — NOT NULL
- SUBCORP — VARCHAR2(5 BYTE)
- RATE_GROUP — VARCHAR2(4 BYTE)
- RATE_CATEGORY — VARCHAR2(2 BYTE)
- CONTENT — VARCHAR2(30 BYTE)
- COMMENTS — VARCHAR2(100 BYTE)
- RATE_GBN — VARCHAR2(2 BYTE)
- RATE_TYPE — VARCHAR2(1 BYTE)
- HOLE_GBN — NUMBER
- ACTIVE_STATUS — VARCHAR2(1 BYTE)
- APPLY_DATE — DATE
- CLOSE_DATE — DATE
- BASIC_COUNT — NUMBER(3,0)
- BASIC_AMOUNT — NUMBER(12,0)
- VAT_STATUS — VARCHAR2(1 BYTE)
- RATE_KIND — VARCHAR2(1 BYTE)
- TYPE_GBN — VARCHAR2(1 BYTE)
- SORT_ORDER — NUMBER(3,0)
- DUMMY_CODE — VARCHAR2(1 BYTE)
- SPLIT_YN — VARCHAR2(1 BYTE)
- APPLY_MAX_DAY — NUMBER
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR2(16 BYTE)
- OLD_RATE_CODE — VARCHAR2(4 BYTE)
mem_class_list
- MEM_NO — VARCHAR(8) — 기본 키 — NOT NULL — 회원번호' COLLATE 'utf8_general_ci
- CORP — VARCHAR(5) — NOT NULL — 업장코드' COLLATE 'utf8_general_ci
- MEM_NAME — VARCHAR(30) — NOT NULL — 회원명' COLLATE 'utf8_general_ci
- CLASS_CODE — VARCHAR(4) — NOT NULL — 등급코드' COLLATE 'utf8_general_ci
- EXPIRE_DATE — VARCHAR(10) — NOT NULL — 만료기간' COLLATE 'utf8_general_ci
- COMMENT — '참고사항' — 참고사항' COLLATE 'utf8_general_ci
- S — VARCHAR(100) — NOT NULL — STATUS` VARCHAR(1) NOT NULL COMMENT '상태값' COLLATE 'utf8_general_ci
- UPDATE_DATE — DATE — 변동일자
- UPDATE_OPER — VARCHAR(16) — 변동한사람' COLLATE 'utf8_general_ci
mem_master
- MEM_NO — VARCHAR(8) — 기본 키 — NOT NULL — 회원번호' COLLATE 'utf8_general_ci
- CORP — VARCHAR(5) — NOT NULL — 업장코드' COLLATE 'utf8_general_ci
- MEM_NAME — VARCHAR(30) — NOT NULL — 회원명' COLLATE 'utf8_general_ci
- MEM_NAME_ENG — VARCHAR(50) — 회원명(영문)' COLLATE 'utf8_general_ci
- MEM_GBN — VARCHAR(2) — 회원구분' COLLATE 'utf8_general_ci
- JOIN_DT — DATE — NOT NULL — 가입일
- BIRTHDAY — VARCHAR(8) — 생년월일' COLLATE 'utf8_general_ci
- SEX — VARCHAR(1) — 성별' COLLATE 'utf8_general_ci
- MEM_TYPE — VARCHAR(2) — 회원유형' COLLATE 'utf8_general_ci
- MEM_NATION — VARCHAR(2) — 국적구분(1:내국인, 2:외국인)' COLLATE 'utf8_general_ci
- MEM_CLASS — VARCHAR(4) — 회원등급' COLLATE 'utf8_general_ci
- EMAIL — VARCHAR(50) — 이메일' COLLATE 'utf8_general_ci
- PHONE1 — VARCHAR(14) — 연락처1' COLLATE 'utf8_general_ci
- PHONE2 — VARCHAR(13) — 연락처2' COLLATE 'utf8_general_ci
- PHONE3 — VARCHAR(13) — 연락처3' COLLATE 'utf8_general_ci
- INSERT_DT — DATE — 입력일시
- INSERT_OPER — VARCHAR(16) — 입력운영자' COLLATE 'utf8_general_ci
- HOUSE_ZIP_CODE — VARCHAR(7) — 자택우편번호' COLLATE 'utf8_general_ci
- HOUSE_ADDR — VARCHAR(200) — 자택주소' COLLATE 'utf8_general_ci
- HOUSE_RNA — VARCHAR(200) — 자택도로명주소' COLLATE 'utf8_general_ci
- OFFICE_ZIP_CODE — VARCHAR(7) — 회사우편번호' COLLATE 'utf8_general_ci
- OFFICE_ADDR — VARCHAR(200) — 회사주소' COLLATE 'utf8_general_ci
- OFFICE_RNA — VARCHAR(200) — 회사도로명주소' COLLATE 'utf8_general_ci
- COMMENT — '참고사항' — 참고사항' COLLATE 'utf8_general_ci
- S — VARCHAR(300) — MARKETING_YN` VARCHAR(1) NULL DEFAULT 'Y' COMMENT '정보활용동의' COLLATE 'utf8_general_ci
- MARKETING_YN_DT — DATE — 정보활용동의 일자
- TRD_OFFER_YN — VARCHAR(1) — 제3자 제공동의' COLLATE 'utf8_general_ci
- TRD_OFFER_YN_DT — DATE — 제3자 제공동의 일자
- SMS_YN — VARCHAR(1) — 문자전송동의' COLLATE 'utf8_general_ci
- SMS_YN_DT — DATE — 문자전송동의 일자
- EMAIL_YN — VARCHAR(1) — 이메일발송동의' COLLATE 'utf8_general_ci
- EMAIL_YN_DT — DATE — 이메일발송동의 일자
- POST_YN — VARCHAR(1) — 우편발송동의' COLLATE 'utf8_general_ci
- POST_GBN — VARCHAR(10) — 우편발송구분' COLLATE 'utf8_general_ci
- POST_YN_DT — DATE — 우편발송동의 일자
- WEB_ID — VARCHAR(30) — 웹회원ID' COLLATE 'utf8_general_ci
- WEB_DT — DATE — 웹회원가입일
- JOIN_GBN — VARCHAR(2) — 가입구분' COLLATE 'utf8_general_ci
- CLUB_NO — VARCHAR(5) — 단체번호' COLLATE 'latin1_bin
- RESV_YN — VARCHAR(1) — 예약가능여부' COLLATE 'latin1_swedish_ci
- STATUS — VARCHAR(1) — 상태' COLLATE 'latin1_swedish_ci
- UPDATE_DATE — DATE — 변경일시
- UPDATE_OPER — VARCHAR(16) — 변경운영자' COLLATE 'latin1_swedish_ci
- HOUSE_ADDR_DTL — VARCHAR(100) — 자택상세주소' COLLATE 'latin1_swedish_ci
- OFFICE_ADDR_DTL — VARCHAR(100) — 회사상세주소' COLLATE 'latin1_swedish_ci
- WEB_PW — VARCHAR(64) — 웹회원패스워드' COLLATE 'latin1_swedish_ci
- AREA_SEQ — DOUBLE(22, 0) — 지역코드
- BIRTH_TYPE — VARCHAR(1) — 생일 (음력:0,양력:1)' COLLATE 'latin1_swedish_ci
- OLD_MEM_NO — VARCHAR(20)
- MEM_IMG — MEDIUMTEXT
- PUBLIC_AGREE — VARCHAR(1) — 퍼블릭 동의 여부' COLLATE 'latin1_swedish_ci
- PUBLIC_AGREE_DT — DATE — 퍼블릭 동의 일자
- AREA_CODE — VARCHAR(5)
- STOP_DATE — DATE
- STOP_OPER — VARCHAR(16)
oper_perm
- PROGRAM_ID — VARCHAR(20) — 기본 키 — NOT NULL
- OPER_ID — VARCHAR(16) — 기본 키 — NOT NULL
- ACTIVE_FLAG — VARCHAR(1)
- PRINT_FLAG — VARCHAR(1)
- EXCEL_FLAG — VARCHAR(1) — NOT NULL
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR(16)
program_list
- PROGRAM_ID — INT(11) — 기본 키 — NOT NULL — 프로그램ID
- PROGRAM_NAME — VARCHAR(50) — 프로그램명' COLLATE 'utf8_general_ci
- PROGRAM_TYPE — VARCHAR(1) — 프로그램구분P:프로그램, M:메뉴' COLLATE 'utf8_general_ci
- PACKAGE_NAME — VARCHAR(20) — 패키지명' COLLATE 'utf8_general_ci
- MENU_TYPE — VARCHAR(1) — MENU_TYPE1:메인,2:이용자' COLLATE 'utf8_general_ci
- PROGRAMMER — VARCHAR(20) — 프로그램작성자' COLLATE 'utf8_general_ci
- IMAGE_INDEX — BIGINT(20) — NOT NULL — 버튼아이콘
- ACTIVE_FLAG — VARCHAR(1) — 사용여부Y:사용, N:미사용' COLLATE 'utf8_general_ci
- COMMENT — '참고사항' — 참고사항' COLLATE 'utf8_general_ci
- S — VARCHAR(4000) — UPDATE_DATE` DATE NULL DEFAULT current_timestamp() COMMENT '최종변경일/시간
- UPDATE_OPER — VARCHAR(16) — 최종변경자' COLLATE 'utf8_general_ci
resv_discount
- RESV_SEQ — INT(11) — 기본 키 — NOT NULL — 예약번호
- CORP — VARCHAR(5) — 업장코드' COLLATE 'utf8_general_ci
- DISCOUNT_CODE — VARCHAR(4) — NOT NULL — 할인코드' COLLATE 'utf8_general_ci
- DISCOUNT_TYPE — VARCHAR(1) — 할인유형' COLLATE 'utf8_general_ci
- DISCOINT_AMOUNT — INT(11) — 할인금액
- RATE_TYPE — VARCHAR(2) — 대상요금유형' COLLATE 'utf8_general_ci
- RATE_CODE — VARCHAR(4) — 대상요금코드' COLLATE 'utf8_general_ci
- CREATE_DATE — DATETIME — 생성일
- CREATE_OPER — VARCHAR(16) — 생성운영자' COLLATE 'utf8_general_ci
- UPDATE_DATE — DATETIME — 최종변경일시
- UPDATE_OPER — VARCHAR(16) — 최종변경자' COLLATE 'utf8_general_ci
resv_master
- CORP — VARCHAR(5) — 업장코드' COLLATE 'utf8_general_ci
- RESV_SEQ — INT(32) — NOT NULL — 예약번호
- RESV_DT — VARCHAR(20) — NOT NULL — 예약일시' COLLATE 'utf8_general_ci
- RESV_GBN — VARCHAR(4) — NOT NULL — 예약구분(1:전화,2:모바일,3:인터넷)' COLLATE 'utf8_general_ci
- PART_GBN — VARCHAR(4) — 파트구분(1:까페, 2:애견샾 ,3:호텔, 4:미용)' COLLATE 'utf8_general_ci
- RATE_CODE — VARCHAR(6) — 요금코드' COLLATE 'utf8_general_ci
- STATUS — VARCHAR(3) — 상태여부' COLLATE 'utf8_general_ci
- UPDATE_DATE — DATETIME — 변경일시
- UPDATE_OPER — VARCHAR(16) — 변경운영자' COLLATE 'utf8_general_ci
- INSERT_DATE — DATETIME — 입력일시
- INSERT_OPER — VARCHAR(16) — 입력운영자' COLLATE 'utf8_general_ci
- RESV_MEM_ID — VARCHAR(50) — 예약자ID' COLLATE 'utf8_general_ci
- RESV_NAME — VARCHAR(30) — 예약자명' COLLATE 'utf8_general_ci
- RESV_TEL — VARCHAR(14) — 예약자번호' COLLATE 'utf8_general_ci
- COMMENT — '참고사항' — 참고사항' COLLATE 'utf8_general_ci'` VARCHAR(300) NULL DEFAULT NULL COMMEN