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)