petmily

Tables (11)

ABANDONED_ANIMAL

  • ABANDONED_ANIMAL_ID — NUMBER(19,0) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • AGE — NUMBER(10,0)
  • KIND — VARCHAR2(255 CHAR)
  • NAME — VARCHAR2(255 CHAR)
  • SPECIES — VARCHAR2(255 CHAR)
  • STATUS — VARCHAR2(255 CHAR)
  • WEIGHT — FLOAT(126)

ADOPT

  • APPLICATION_ID (APPLICATION_ID2) — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
  • JOB — VARCHAR2(255 CHAR)
  • LOCATION — NUMBER(10,0)
  • MARRIED — NUMBER(1,0)

APPLICATION

  • APPLICATION_ID — NUMBER(19,0) — Primary key — NOT NULL
  • APP_TYPE — VARCHAR2(31 CHAR) — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • APPLICATION_STATUS — VARCHAR2(255 CHAR)
  • MEMBER_ID — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ABANDONED_ANIMAL_ID — NUMBER(19,0) — Foreign key → ABANDONED_ANIMAL.ABANDONED_ANIMAL_ID — NOT NULL

BOARD

  • BOARD_ID — NUMBER(19,0) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • BOARD_TYPE — VARCHAR2(255 CHAR)
  • CONTENT — VARCHAR2(255 CHAR)
  • SHOWN_ALL — NUMBER(1,0)
  • TITLE — VARCHAR2(255 CHAR)
  • MEMBER_ID (MEMBER_ID2) — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL

DONATION

  • APPLICATION_ID (APPLICATION_ID2) — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
  • ACCOUNT_NUMBER — NUMBER(19,0)
  • ACCOUNT_NUMBER_WITH_HYPHEN — VARCHAR2(255 CHAR)
  • AMOUNT — NUMBER(10,0)
  • BANK_TYPE — VARCHAR2(255 CHAR)
  • DONATOR — VARCHAR2(255 CHAR)

FIND_WATCH_BOARD

  • BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL
  • ANIMAL_AGE — NUMBER(10,0)
  • ANIMAL_KIND — VARCHAR2(255 CHAR)
  • ANIMAL_NAME — VARCHAR2(255 CHAR)
  • ANIMAL_WEIGHT — FLOAT(126)
  • BOARD_STATUS — NUMBER(10,0)
  • LOST_OR_WATCH_TIME — TIMESTAMP
  • SPECIES — NUMBER(10,0)

MATCH_INFO

  • ID — NUMBER(19,0) — Primary key — NOT NULL
  • MATCHED_BOARD_BOARD_ID — NUMBER(19,0) — Foreign key → FIND_WATCH_BOARD.BOARD_ID — NOT NULL
  • TARGET_BOARD_BOARD_ID — NUMBER(19,0) — Foreign key → FIND_WATCH_BOARD.BOARD_ID — NOT NULL

MEMBER

  • MEMBER_ID — NUMBER(19,0) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • BIRTH — DATE
  • DOMAIN — VARCHAR2(255 CHAR)
  • ID — VARCHAR2(255 CHAR)
  • SITE — VARCHAR2(255 CHAR)
  • GRADE — VARCHAR2(255 CHAR)
  • LOGIN_ID — VARCHAR2(255 CHAR)
  • NAME — VARCHAR2(255 CHAR)
  • PASSWORD — VARCHAR2(255 CHAR)
  • END_NUMBER — VARCHAR2(255 CHAR)
  • MIDDLE_NUMBER — VARCHAR2(255 CHAR)
  • START_NUMBER — VARCHAR2(255 CHAR)

PICTURE

  • PICTURE_ID — NUMBER(19,0) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • FILE_STORE_NAME — VARCHAR2(255 CHAR)
  • FILE_UPLOAD_NAME — VARCHAR2(255 CHAR)
  • BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL
  • ABANDONED_ANIMAL_ID (ABANDONED_ANIMAL_ID2) — NUMBER(19,0) — Foreign key → ABANDONED_ANIMAL.ABANDONED_ANIMAL_ID — NOT NULL

REPLY

  • REPLY_ID — NUMBER(19,0) — Primary key — NOT NULL
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP
  • CONTENT — VARCHAR2(255 CHAR)
  • MEMBER_ID (MEMBER_ID2) — NUMBER(19,0) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • BOARD_ID (BOARD_ID2) — NUMBER(19,0) — Foreign key → BOARD.BOARD_ID — NOT NULL

TEMPORARY_PROTECTION

  • APPLICATION_ID — NUMBER(19,0) — Foreign key → APPLICATION.APPLICATION_ID — NOT NULL
  • JOB — VARCHAR2(255 CHAR)
  • LOCATION — NUMBER(10,0)
  • MARRIED — NUMBER(1,0)
  • PERIOD — NUMBER(10,0)