애견샾

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