animal_Table
Tables (9)
ANIMAL_HOSPITAL
- ANIMAL_HOSPITAL_ID — VARCHAR2(100) — Primary key — NOT NULL
- ANIMAL_HOSPITAL_NAME — VARCHAR2(100)
- ANIMAL_HOSPITAL_ADDRESS — VARCHAR2(100)
- ANIMAL_HOSPITAL_PHONE — VARCHAR2(20)
- ANIMAL_HOSPITAL_LATITUDE — NUMBER(12,5)
- ANIMAL_HOSPITAL_LONGITUDE — NUMBER(12,5)
ANIMAL_MEMBER
- ANIMAL_MEMBER_ID — VARCHAR2(100) — Primary key — NOT NULL
- ANIMAL_MEMBER_PWD — VARCHAR2(100)
- ANIMAL_MEMBER_AGE — VARCHAR2(50)
- ANIMAL_MEMBER_NAME — VARCHAR2(50)
- ANIMAL_MEMBER_GENDER — VARCHAR2(50)
- ANIMAL_MEMBER_JOINDATE — DATE
- ANIMAL_MEMBER_EMAIL — VARCHAR2(100)
- ANIMAL_MEMBER_NICKNAME — VARCHAR2(100)
- ANIMAL_MEMBER_NAVER_ID — VARCHAR2(50)
- ANIMAL_MEMBER_GOOGLE_ID — VARCHAR2(50)
- ANIMAL_MEMBER_KAKAO_ID — VARCHAR2(50)
- ANIMAL_MEMBER_FACEBOOK_ID — VARCHAR2(50)
BOARD
- BOARD_BNO — NUMBER(10) — Primary key — NOT NULL
- ANIMAL_MEMBER_ID (BOARD_ID) — VARCHAR2(100) — Foreign key → ANIMAL_MEMBER.ANIMAL_MEMBER_ID — NOT NULL
- BOARD_CATEGORY — VARCHAR2(30)
- BOARD_TITLE — VARCHAR2(200)
- BOARD_CONTENT — VARCHAR2(2000)
- BOARD_READCOUNT — NUMBER(4)
- BOARD_THUMBNAIL — VARCHAR2(100)
- BOARD_WRITEDATE — DATE
- BOARD_COMMENT_COUNT — NUMBER(10)
- BOARD_LIKE_IT — NUMBER(10)
- BOARD_HASHTAG — VARCHAR2(100)
BOARD_COMMENT
- BOARD_COMMENT_NUM — NUMBER(10) — Primary key — NOT NULL
- BOARD_BNO (BOARD_COMMENT_BNO) — NUMBER(10) — Foreign key → BOARD.BOARD_BNO — NOT NULL
- BOARD_COMMENT_ID — VARCHAR2(30)
- BOARD_COMMENT_CONTENT — VARCHAR2(500)
- BOARD_COMMENT_WRITEDATE — DATE
BOARD_IMAGE
- BOARD_IMAGE_FILE_NO — NUMER(10) — Primary key — NOT NULL
- BOARD_BNO (BOARD_IMAGE_BNO) — NUMBER(10) — Foreign key → BOARD.BOARD_BNO — NOT NULL
- BOARD_IMAGE_FILE_NAME — VARCHAR2(255)
- BOARD_IMAGE_REG_DATE — DATE
PRODUCT
- PRODUCT_ID — NUMBER(10) — Primary key — NOT NULL
- PRODUCT_ANIMAL_TYPE — VARCHAR2(20)
- PRODUCT_NAME — VARCHAR2(100)
- PRODUCT_CATEGORY — VARCHAR2(30)
- PRODUCT_DESCRIPTION — VARCHAR2(300)
- PRODUCT_PRICE — NUMBER(10)
- PRODUCT_QUANTITY — NUMBER(10)
- PRODUCT_IMAGE_URL — VARCHAR2(500)
- PRODUCT_LINK — VARCHAR2(500)
PRODUCT_ATTRIBUTE
- PRODUCT_ATTRIBUTE_ID — NUMBER(10) — Primary key — NOT NULL
- PRODUCT_ID (PRODUCT_ATTRIBUTE_PRODUCT_ID) — NUMBER(10) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- PRODUCT_ATTRIBUTE_NAME — VARCHAR2(50)
- PRODUCT_ATTRIBUTE_VALUE — VARCHAR2(50)
PRODUCT_CART
- PRODUCT_CART_ID — NUMBER(10) — Primary key — NOT NULL
- ANIMAL_MEMBER_ID (PRODUCT_CART_MEMBER_ID) — VARCHAR2(100) — Foreign key → ANIMAL_MEMBER.ANIMAL_MEMBER_ID — NOT NULL
- PRODUCT_ID (PRODUCT_CART_PRODUCT_ID) — NUMBER(10) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- PRODUCT_CART_QUANTITY — NUMBER(5)
- PRODUCT_CART_PRODUCT_NAME — VARCHAR2(100)
- PRODUCT_CART_IMAGE_URL — VARCHAR2(500)
PRODUCT_PAYMENT
- PRODUCT_PAYMENT{_PAYMENTKEY (PRODUCT_PAYMENT_PAYMENTKEY) — NUMBER(10) — Primary key — NOT NULL
- ANIMAL_MEMBER_ID (PRODUCT_PAYMENT_MEMBER_ID) — VARCHAR2(100) — Foreign key → ANIMAL_MEMBER.ANIMAL_MEMBER_ID — NOT NULL
- PRODUCT_PAYMENT_ORDER_ID — VARCHAR2(200)
- PRODUCT_PAYMENT_AMOUNT — NUMBER(10)