내옆Pet
테이블 (23)
ADMIN (관리자)
- CART_IDX (ADM_IDX) — NUMBER — 기본 키
- email (ADM_NAME) — VARCHAR2(30) — NOT NULL
- (ADM_MGR) — VARCHAR2(256) — NOT NULL
- created_at (ADM_PW) — DATETIME — NOT NULL
- gender (ADM_EMAIL) — BOOLEAN
- birth (ADM_ID) — DATE
- Field (ADM_JOIN)
- Field (ADM_ACCESS)
- Field (ADM_CLOSE)
ADOPT (입양리스트)
- CART_IDX (ADT_IDX) — NUMBER — 기본 키
- name (ADT_NAME) — VARCHAR2(30) — NOT NULL
- email (ADT_GENDER) — VARCHAR2(30) — NOT NULL
- (ADT_AGE) — VARCHAR2(256) — NOT NULL
- created_at (ADT_VARIETY) — DATETIME — NOT NULL
- gender (ADT_WEIGHT) — BOOLEAN
- birth (ADT_INFO) — DATE
- Field (ADT_IMG)
- Field (ADT_STATE)
ANSWER (문의사항 답변)
- CART_IDX (ANS_IDX) — NUMBER — 기본 키
- email (ANS_TITLE) — VARCHAR2(30) — NOT NULL
- (ADM_IDX) — VARCHAR2(256) — NOT NULL
- created_at (ANS_INFO) — DATETIME — NOT NULL
- Field (ANS_FILE)
- Field (ANS_DATE)
- Field (ANS_IMG)
- Field (INQ_IDX)
- Field (PK)
CALL112 (제보)
- P_KATE_IDX (112_IDX) — NUMBER — 기본 키 — NOT NULL
- (112_IMG) — VARCHAR2(256) — NOT NULL
- Field (112_INFO)
- Field (112_DATE)
- Field (112_TITLE)
- Field (112_LOCAL)
- Field (PK)
CART (장바구니)
- CART_IDX — NUMBER — 기본 키
- name (PK) — VARCHAR2(30) — NOT NULL
- email (PDT_ CNT) — VARCHAR2(30) — NOT NULL
- (PDT_IDX) — VARCHAR2(256) — NOT NULL
- created_at (PDT_NAME) — DATETIME — NOT NULL
- gender (PDT_SALEPRICE) — BOOLEAN
- birth (PDT_PRICE) — DATE
- Field (PDT_IMG)
COMMENT (댓글/답글)
- Field (CMT_IDX) — 기본 키
- email (CMT_INFO) — VARCHAR2(30) — NOT NULL
- (CMT_DATE) — VARCHAR2(256) — NOT NULL
- created_at (PK) — DATETIME — NOT NULL
- gender (CMT_UPDATE) — BOOLEAN
- birth (CMT_IMG) — DATE
- Field (CMT_LCNT)
- Field (CMT_HCNT)
- Field (CMT_STEP)
- Field (CMT_LEVEL)
- CART_IDX (CMT_REF) — NUMBER
- Field (POST_IDX)
CORPARATION (지점정보)
- CART_IDX (CORP_IDX) — NUMBER — 기본 키
- name (CORP_NAME) — VARCHAR2(30) — NOT NULL
- email (CORP_PHONE) — VARCHAR2(30) — NOT NULL
- (CORP_LOCAL) — VARCHAR2(256) — NOT NULL
- created_at (CORP_ADDR) — DATETIME — NOT NULL
- gender (CORP_INFO) — BOOLEAN
- birth (CORP_IMG) — DATE
GOOGLE (구글로그인)
- MBR_IDX (9GLE_UID) — NUMBER — 기본 키 — NOT NULL
- email (9GLE_EMAIL) — VARCHAR2(30) — NOT NULL
- p_number (9GLE_CELL) — VARCHAR2(11) — NOT NULL
- gender (TELEPHONE) — BOOLEAN
- birth (NAME) — DATE
- created_at (BIRTH) — DATETIME — NOT NULL
- updated_at (GENDER) — DATETIME — NOT NULL
- Field (JOIN)
- Field (ADDRESS)
- Field (NICKNAME)
- Field (PNT_POINT)
- Field (ACCESS)
- Field (WITHDRAW)
- Field (ATTENTION)
- Field (PATH)
- Field (PICTURE)
- Field (MBR_LIKE)
HOSPITAL (동물병원정보)
- CART_IDX (HPT_IDX) — NUMBER — 기본 키
- name (HPT_NAME) — VARCHAR2(30) — NOT NULL
- email (KATE_IDX) — VARCHAR2(30) — NOT NULL
- (HPT_ADDR) — VARCHAR2(256) — NOT NULL
- created_at (HPT_OWNER) — DATETIME — NOT NULL
- gender (HPT_PARK) — BOOLEAN
- birth (HPT_TELL) — DATE
- Field (HPT_TYPE)
- Field (HPT_IMG)
- Field (HPT_SBJ)
- Field (HPT_LCNT)
- Field (HPT_STAR)
INQUIRE (문의사항)
- CART_IDX (INQ_IDX) — NUMBER — 기본 키
- email (INQ_TITLE) — VARCHAR2(30) — NOT NULL
- (PK) — VARCHAR2(256) — NOT NULL
- created_at (INQ_|INFO) — DATETIME — NOT NULL
- Field (NOTICE_FILE)
- Field (NOTICE_DATE)
- Field (NOTICE_IMG)
- Field (KATE_IDX)
KAKAO (카카오로그인)
- email (EMAIL) — VARCHAR2(30) — 기본 키 — NOT NULL
- p_number (CELL) — VARCHAR2(11) — NOT NULL
- gender (TELEPHONE) — BOOLEAN
- birth (NAME) — DATE
- created_at (BIRTH) — DATETIME — NOT NULL
- updated_at (GENDER) — DATETIME — NOT NULL
- Field (JOIN)
- Field (NICKNAME)
- Field (ADDRESS)
- Field (PNT_POINT)
- Field (ACCESS)
- Field (WITHDRAW)
- Field (ATTENTION)
- Field (PATH)
- Field (PICTURE)
- Field (MBR_LIKE)
KATEGORIE (상품카테고리)
- P_KATE_IDX (KATE_IDX) — NUMBER — 기본 키 — NOT NULL
- (KATE_NAME) — VARCHAR2(256) — NOT NULL
- Field (KATE_KIND)
- Field (KATE_STATE)
MEMBER (개인정보)
- MBR_IDX — NUMBER — 기본 키 — NOT NULL
- (ID) — VARCHAR2(256) — NOT NULL
- name (PW) — VARCHAR2(30) — NOT NULL
- email (EMAIL) — VARCHAR2(30) — NOT NULL
- p_number (CELL) — VARCHAR2(11) — NOT NULL
- gender (TELEPHONE) — BOOLEAN
- birth (NAME) — DATE
- created_at (BIRTH) — DATETIME — NOT NULL
- updated_at (GENDER) — DATETIME — NOT NULL
- Field (JOIN)
- Field (ADDRESS)
- Field (NICKNAME)
- Field (PNT_POINT)
- Field (ACCESS)
- Field (WITHDRAW)
- Field (ATTENTION)
- Field (PATH)
- Field (PICTURE)
- Field (MBR_LIKE)
NAVER (네이버로그인)
- 네이버 회원 이메일 (NVR_EMAIL) — VARCHAR2(40) — 기본 키 — NOT NULL — 네이버 회원 이메일
- 핸드폰번호 (CELLPHONE) — NUMBER — NOT NULL — 네이버 회원 핸드폰 번호
- 네이버 회원 집전화 (TELEPHONE) — NUMBER — 네이버 회원 집 전화번호
- birth (NAME) — DATE
- created_at (BIRTH) — DATETIME — NOT NULL
- updated_at (GENDER) — DATETIME — NOT NULL
- Field (JOIN)
- Field (ADDRESS)
- Field (PNT_POINT)
- Field (ACCESS)
- Field (WITHDRAW)
- Field (ATTENTION)
- Field (PATH)
- Field (PICTURE)
- Field (MBR_LIKE)
- Field (NVR_NICKNAME)
NOTIFICATION/EVENT (공지사항/이벤트)
- CART_IDX (NOTICE_IDX) — NUMBER — 기본 키
- email (NOTICE_TITLE) — VARCHAR2(30) — NOT NULL
- (ADM_IDX) — VARCHAR2(256) — NOT NULL
- created_at (NOTICE_INFO) — DATETIME — NOT NULL
- gender (NOTICE_HIT) — BOOLEAN
- birth (NOTICE_VISIBLE) — DATE
- Field (NOTICE_FILE)
- Field (NOTICE_DATE)
- Field (NOTICE_IMG)
- Field (NOTICE_STATE)
- Field (NOTICE_PRIORTY)
ORDER (주문완료)
- OD_IDX — NUMBER — 기본 키
- name (PK) — VARCHAR2(30) — NOT NULL
- (PDT_IDX) — VARCHAR2(256) — NOT NULL
- created_at (PDT_NAME) — DATETIME — NOT NULL
- Field (PDT_IMG)
- gender (PDT_SALEPRICE) — BOOLEAN
- birth (PDT_PRICE) — DATE
- Field (PDT_CNT)
- Field (OD_ARV)
- Field (OD_LEAVE)
- Field (OD_DVR_NAME)
- Field (OD_DVR_ADDR)
- Field (OD_DVR_PHONE)
- Field (OD_DVR_REQ)
ORGAN (조직도)
- CART_IDX (ORG_IDX) — NUMBER — 기본 키
- name (CORP_IDX) — VARCHAR2(30) — NOT NULL
- email (ORG_EMPNO) — VARCHAR2(30) — NOT NULL
- (ORG_MGR) — VARCHAR2(256) — NOT NULL
- created_at (ORG_JOB) — DATETIME — NOT NULL
- gender (ORG_DIV) — BOOLEAN
- birth (ORG_NAME) — DATE
- Field (ORG_INFO)
PET (펫)
- PET_IDX — NUMBER — 기본 키 — NOT NULL
- MBR_IDX (PK) — NUMBER — 외래 키 → MEMBER.MBR_IDX — NOT NULL
- (PET_TYPE) — VARCHAR2(256) — NOT NULL
- name (PET_NAME) — VARCHAR2(30) — NOT NULL
- email (PET_TITLE) — VARCHAR2(30) — NOT NULL
- p_number (PET_WEIGHT) — VARCHAR2(11) — NOT NULL
- gender (PET_BIRTH) — BOOLEAN
- birth (PET_DEAD) — DATE
- created_at (PET_PICTURE) — DATETIME — NOT NULL
- updated_at (PET_CERT) — DATETIME — NOT NULL
- Field (PET_SUBTYPE)
POINT (포인트)
- P_KATE_IDX (PNT_IDX) — NUMBER — 기본 키 — NOT NULL
- (PNT_NOW) — VARCHAR2(256) — NOT NULL
- Field (PNT_IN)
- Field (PNT_OUT)
- Field (PK)
- Field (PNT_TOTAL)
- Field (PNT_RECORD)
POST (게시글 정보)
- CART_IDX (POST_IDX) — NUMBER — 기본 키
- name (POST_TITLE) — VARCHAR2(30) — NOT NULL
- email (POST_INFO) — VARCHAR2(30) — NOT NULL
- (POST_DATE) — VARCHAR2(256) — NOT NULL
- created_at (PK) — DATETIME — NOT NULL
- gender (POST_UPDATE) — BOOLEAN
- birth (POST_IMG) — DATE
- Field (POST_FILE)
- Field (POST_LCNT)
- Field (POST_HCNT)
- Field (POST_HIT)
- Field (POST_NUM)
PRODUCT (상품정보)
- PDT_IDX — NUMBER — 기본 키
- (PDT_COMP_IDX) — VARCHAR2(256) — NOT NULL
- name (PDT_COMP_NAME) — VARCHAR2(30) — NOT NULL
- email (KATE_IDX) — VARCHAR2(30) — NOT NULL
- p_number (PDT_PRICE) — VARCHAR2(11) — NOT NULL
- gender (PDT_INFO) — BOOLEAN
- birth (PDT_IMG) — DATE
- created_at (PDT_NAME) — DATETIME — NOT NULL
- updated_at (PDT_LCNT) — DATETIME — NOT NULL
- Field (PDT_ODCNT)
- Field (PDT_CNT)
- Field (PDT_STAR)
REVIEW (리뷰)
- P_KATE_IDX (RVW_IDX) — NUMBER — 기본 키 — NOT NULL
- (PK) — VARCHAR2(256) — NOT NULL
- Field (RVW_INFO)
- Field (RVW_STAR)
- Field (RVW_STATE)
- Field (RVW_REF)
- Field (RVW_IMG)
- Field (RVW_DATE)
- Field (RVW_CERT)
- Field (RVW_UPDATE)
SEEUAGAIN (추모)
- CART_IDX (SUAG_IDX) — NUMBER — 기본 키
- name (SUAG_DATE) — VARCHAR2(30) — NOT NULL
- email (PK) — VARCHAR2(30) — NOT NULL
- (PET_IDX) — VARCHAR2(256) — NOT NULL
- created_at (SUAG_FILE) — DATETIME — NOT NULL
- gender (SUAG_INFO) — BOOLEAN
- birth (SUAG_DEAD) — DATE
- Field (PET_TITLE)
- Field (PET_NAME)
- Field (PET_IMG)
- Field (SUAG_SCOPE)
- Field (SUAG_LCNT)
- Field (CMT_IDX)