애견샾 매장관리 프로그램 schema
테이블 (5)
CLUB_INFO
- CLUB_NO — VARCHAR2(8 BYTE) — 기본 키 — NOT NULL
- CORP — VARCHAR2(5 BYTE) — NOT NULL
- CLUB_NAME — VARCHAR2(30 BYTE) — NOT NULL
- CLUB_GBN — VARCHAR2(2 BYTE)
- CLUB_CLASS — VARCHAR2(2 BYTE)
- JOIN_DT — DATE — NOT NULL
- CP_NAME — VARCHAR2(30 BYTE)
- CP_PHONE1 — VARCHAR2(13 BYTE)
- CP_ZIP_CODE — VARCHAR2(7 BYTE)
- CP_ADDR — VARCHAR2(200 BYTE)
- CP_RNA — VARCHAR2(200 BYTE)
- CP_ADDR_DTL — VARCHAR2(100 BYTE)
- CP_IMG — NUMBER(13,0)
- CS_NAME — VARCHAR2(30 BYTE)
- CS_PHONE1 — VARCHAR2(13 BYTE)
- CS_ZIP_CODE — VARCHAR2(5 BYTE)
- CS_ADDR — VARCHAR2(200 BYTE)
- CS_RNA — VARCHAR2(200 BYTE)
- CS_ADDR_DTL — VARCHAR2(100 BYTE)
- CS_IMG — NUMBER(13,0)
- CLUB_GC — VARCHAR2(50 BYTE)
- COMMENTS — VARCHAR2(300 BYTE)
- TEAM_CNT — VARCHAR2(20 BYTE)
- HOPE_WEEK — VARCHAR2(2 BYTE)
- HOPE_DAY — VARCHAR2(2 BYTE)
- HOPE_TIME — VARCHAR2(2 BYTE)
- START_DATE — DATE
- END_DATE — DATE
- CLUB_PHONE — VARCHAR2(13 BYTE)
- STATUS — VARCHAR2(1 BYTE)
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR2(16 BYTE)
- OLD_CLUB_NO — VARCHAR2(10 BYTE)
- CP_SMS_YN — VARCHAR2(1 BYTE)
- CP_POST_YN — VARCHAR2(1 BYTE)
- CS_SMS_YN — VARCHAR2(1 BYTE)
- CS_POST_YN — VARCHAR2(1 BYTE)
- CP_MEM_NO — VARCHAR2(8 BYTE)
- CS_MEM_NO — VARCHAR2(8 BYTE)
- CLUB_TYPE — VARCHAR2(2 BYTE)
- JOIN_OPER — VARCHAR2(16 BYTE)
- DISCONNECT_DT — DATE
- DISCONNECT_RSN — VARCHAR2(4 BYTE)
- DISCONNECT_OPER — VARCHAR2(16 BYTE)
- CP_PHONE2 — VARCHAR2(13 BYTE)
- CS_PHONE2 — VARCHAR2(13 BYTE)
- AREA_CODE — VARCHAR2(5 BYTE)
- CLUB_REQUEST — VARCHAR2(300 BYTE)
- UPDATE_RSN — VARCHAR2(20 BYTE)
MEM_CLASS_LIST
- MEM_NO (MEM_NO2) — VARCHAR(8) — 외래 키 → mem_master.MEM_NO — NOT NULL — 회원번호' COLLATE 'latin1_swedish_ci
- CORP — VARCHAR2(5 BYTE) — NOT NULL
- MEM_NAME — VARCHAR2(30 BYTE) — NOT NULL
- CLASS_CODE — VARCHAR2(4 BYTE) — NOT NULL
- EXPIRE_DATE — VARCHAR2(10 BYTE) — NOT NULL
- COMMENTS — VARCHAR2(100 BYTE)
- STATUS — VARCHAR2(1 BYTE) — NOT NULL
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR2(16 BYTE)
RESV_MASTER
- RESV_SEQ — NUMBER(32,0) — 기본 키 — NOT NULL
- CORP — VARCHAR2(5 BYTE) — NOT NULL
- RESV_DT — DATE
- RESV_GBN — VARCHAR2(4 BYTE)
- SC_DT — DATE — NOT NULL
- SC_SEQ — NUMBER(13,0) — NOT NULL
- COURSE — VARCHAR2(4 BYTE) — NOT NULL
- NEXT_COURSE — VARCHAR2(4 BYTE)
- PLAY_TM — VARCHAR2(4 BYTE) — NOT NULL
- LOCK_OPER — VARCHAR2(30 BYTE)
- HOLE_GBN — VARCHAR2(2 BYTE)
- RATE_CODE — VARCHAR2(6 BYTE)
- CADDIE_ID — VARCHAR2(20 BYTE)
- INSERT_DT — DATE
- INSERT_OPER — VARCHAR2(16 BYTE)
- RESV_SEQ_NO — VARCHAR2(32 BYTE)
- RESV_MEM_NO — VARCHAR2(8 BYTE)
- RESV_NAME — VARCHAR2(30 BYTE)
- RESV_TEL — VARCHAR2(14 BYTE)
- CLUB_NO — VARCHAR2(30 BYTE)
- CLUB_NAME — VARCHAR2(30 BYTE)
- COMMENTS — VARCHAR2(200 BYTE)
- PART_CODE — VARCHAR2(2 BYTE)
- RESV_SMS — VARCHAR2(1 BYTE)
- VHC_ID — NUMBER
- STATUS — VARCHAR2(1 BYTE)
- AMOUNT — NUMBER
- ACTIVE_STATUS — VARCHAR2(10 BYTE)
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR2(16 BYTE)
- LOCK_DT — DATE
- FIX_DATE — DATE
- FIX_OPER — VARCHAR2(16 BYTE)
- IN_COMMENTS — VARCHAR2(300 BYTE)
- PLAY_COMMENTS — VARCHAR2(300 BYTE)
- RATE_COMMENTS — VARCHAR2(300 BYTE)
- CART_CNT — NUMBER
- CART_RATE — VARCHAR2(4 BYTE)
- LEDGER_DATE — DATE
- LEDGER_SEQ — NUMBER
- BREAKFAST_CNT — NUMBER(1,0)
- RESV_SEX — VARCHAR2(1 BYTE)
- RESV_ORD_COMMENTS — VARCHAR2(300 BYTE)
- RATE_ORD_COMMENTS — VARCHAR2(300 BYTE)
- PLAY_ORD_COMMENTS — VARCHAR2(300 BYTE)
- CHAIN_RESV_SEQ — NUMBER
- LOCKER_MSG_CHK — NUMBER
- STORE_COMMENTS — VARCHAR2(300 BYTE)
- UPDATE_RSN — VARCHAR2(255 BYTE)
- RESV_INFO_LINK1 — VARCHAR2(200 BYTE)
VISITOR_LIST
- SEQ_NO — NUMBER — 기본 키 — NOT NULL
- CREATE_DATE — DATE
- RESV_SEQ — VARCHAR2(10 BYTE)
- MEM_SEQ — VARCHAR2(1 BYTE)
- TEL_NO — VARCHAR2(13 BYTE)
- UPDATE_DATE — DATE
- UPDATE_OPER — VARCHAR2(16 BYTE)
mem_master
- MEM_NO — VARCHAR(8) — 기본 키 — NOT NULL — 회원번호' COLLATE 'latin1_swedish_ci
- CORP — VARCHAR(5) — NOT NULL — 업장코드' COLLATE 'latin1_swedish_ci
- MEM_NAME — VARCHAR(30) — NOT NULL — 회원명' COLLATE 'latin1_swedish_ci
- MEM_NAME_ENG — VARCHAR(50) — 회원명(영문)' COLLATE 'latin1_swedish_ci
- MEM_GBN — VARCHAR(2) — 회원구분' COLLATE 'latin1_swedish_ci
- JOIN_DT — DATE — NOT NULL — 가입일
- BIRTHDAY — VARCHAR(8) — 생년월일' COLLATE 'latin1_swedish_ci
- SEX — VARCHAR(1) — 성별' COLLATE 'latin1_swedish_ci
- MEM_TYPE — VARCHAR(2) — 회원유형' COLLATE 'latin1_swedish_ci
- MEM_NATION — VARCHAR(2) — 국적구분(1:내국인, 2:외국인)' COLLATE 'latin1_swedish_ci
- MEM_CLASS — VARCHAR(4) — 회원등급' COLLATE 'latin1_swedish_ci
- EMAIL — VARCHAR(50) — 이메일' COLLATE 'latin1_swedish_ci
- PHONE1 — VARCHAR(14) — 연락처1' COLLATE 'latin1_swedish_ci
- PHONE2 — VARCHAR(13) — 연락처2' COLLATE 'latin1_swedish_ci
- PHONE3 — VARCHAR(13) — 연락처3' COLLATE 'latin1_swedish_ci
- INSERT_DT — DATE — 입력일시
- INSERT_OPER — VARCHAR(16) — 입력운영자' COLLATE 'latin1_swedish_ci
- HOUSE_ZIP_CODE — VARCHAR(7) — 자택우편번호' COLLATE 'latin1_swedish_ci
- HOUSE_ADDR — VARCHAR(200) — 자택주소' COLLATE 'latin1_swedish_ci
- HOUSE_RNA — VARCHAR(200) — 자택도로명주소' COLLATE 'latin1_swedish_ci
- OFFICE_ZIP_CODE — VARCHAR(7) — 회사우편번호' COLLATE 'latin1_swedish_ci
- OFFICE_ADDR — VARCHAR(200) — 회사주소' COLLATE 'latin1_swedish_ci
- OFFICE_RNA — VARCHAR(200) — 회사도로명주소' COLLATE 'latin1_swedish_ci
- COMMENT — '참고사항' — 참고사항' COLLATE 'latin1_swedish_ci
- S — VARCHAR(300) — MARKETING_YN` VARCHAR(1) NULL DEFAULT 'Y' COMMENT '정보활용동의' COLLATE 'latin1_swedish_ci
- MARKETING_YN_DT — DATE — 정보활용동의 일자
- TRD_OFFER_YN — VARCHAR(1) — 제3자 제공동의' COLLATE 'latin1_swedish_ci
- TRD_OFFER_YN_DT — DATE — 제3자 제공동의 일자
- SMS_YN — VARCHAR(1) — 문자전송동의' COLLATE 'latin1_swedish_ci
- SMS_YN_DT — DATE — 문자전송동의 일자
- EMAIL_YN — VARCHAR(1) — 이메일발송동의' COLLATE 'latin1_swedish_ci
- EMAIL_YN_DT — DATE — 이메일발송동의 일자
- POST_YN — VARCHAR(1) — 우편발송동의' COLLATE 'latin1_swedish_ci
- POST_GBN — VARCHAR(10) — 우편발송구분' COLLATE 'latin1_swedish_ci
- POST_YN_DT — DATE — 우편발송동의 일자
- HANDY — SMALLINT(6) — 핸디캡
- HANDY_DT — DATE — 핸디캡갱신일
- CAR_NO — VARCHAR(13) — 차량번호' COLLATE 'latin1_swedish_ci
- CAR_NAME — VARCHAR(30) — 차량명(종류)' COLLATE 'latin1_swedish_ci
- WEB_ID — VARCHAR(30) — 웹회원ID' COLLATE 'latin1_swedish_ci
- WEB_DT — DATE — 웹회원가입일
- JOIN_GBN — VARCHAR(2) — 가입구분' COLLATE 'latin1_swedish_ci
- CLUB_NO — VARCHAR(5) — 단체번호' COLLATE 'latin1_swedish_ci
- 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)
- MEM_NO (MEM_NO2) — VARCHAR(8) — 외래 키 → mem_master.MEM_NO — NOT NULL — 회원번호' COLLATE 'latin1_swedish_ci
- … +1