내옆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)