test

Tables (18)

AdoptionConfirmation

  • M_ID — varchar2(50) — Foreign key — NOT NULL
  • AC_CHECK — varchar2(1000)
  • AC_ID — varchar2(100)
  • AC_ClassIfication — varchar2(100)
  • AC_breed — varchar2(100)
  • AC_Area — varchar2(100)
  • AC_Gender — varchar2(10)
  • AC_RegistrationNumber — varchar2(100)
  • AC_ConfirmationDate — DATE

AnonymousBoard

  • A_NUMBER — VARCHAR(255) — Primary key — NOT NULL
  • A_NICK — varchar2(100)
  • A_PWD — varchar2(100)
  • A_CONTENT — varchar2(3000)

BANK

  • B_CODE — varchar2(10) — Primary key — NOT NULL
  • B_TITLE — varchar2(30) — NOT NULL

BuyConfirmation

  • M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
  • BC_CHECK — varchar2(1000)
  • BC_ID — varchar2(100)
  • BC_ClassIfication — varchar2(100)
  • BC_breed — varchar2(100)
  • BC_Area — varchar2(100)
  • BC_Gender — varchar2(10)
  • BC_RegistrationNumber — varchar2(100)
  • BC_ConfirmationDate — DATE

BuyerApply

  • B_PET — varchar2(50) — Primary key — NOT NULL
  • B_ID — varchar2(50) — Foreign key — NOT NULL
  • B_CODE — varchar2(10) — Foreign key — NOT NULL
  • B_BANK — varchar2(100) — NOT NULL

CopyOfADOPT

  • M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
  • PID — number — Foreign key → CopyOfPARCELOUT.PID — NOT NULL
  • ANIMAL — varchar2(20)
  • KIND — varchar2(20)
  • LOCATION — varchar2(100)
  • GENDER — varchar2(15)
  • TIME — varchar2(50)

CopyOfPARCELOUT

  • PID — number — Primary key — NOT NULL
  • M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
  • Key — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
  • PIC — varchar2(50)
  • EXPLANATION — varchar2(1000)
  • DEPOSIT — varchar2(50)
  • TIME — varchar2(50)

CopyOfUntitled3

  • Key — number — Primary key — NOT NULL
  • Field2 — varchar2(100)
  • Field3 — varchar2(50)
  • Field4 — varchar2(1000)
  • Field5 — date

DIVISION

  • D_DIVISION — varchar2(10) — Primary key — NOT NULL
  • D_TITLE — varchar2(20) — NOT NULL

LOGIN

  • L_ID — varchar2(50) — NOT NULL
  • L_LOGINTIME — date — NOT NULL

MEMBER

  • M_NO — number — Primary key — NOT NULL
  • M_ID — varchar2(50) — Primary key — NOT NULL
  • M_NAME — varchar2(30) — NOT NULL
  • M_PASSWORD — varchar2(60) — NOT NULL
  • M_EMAIL — varchar2(100) — NOT NULL
  • M_ADDRESS — varchar2(200) — NOT NULL
  • M_PHONE — varchar2(100) — NOT NULL
  • M_CODE — varchar2(10)
  • M_ACCOUNT — varchar2(50)
  • M_DIVISION — varchar2(10) — NOT NULL
  • M_REGISTRATION — varchar2(50)
  • M_JOINDATE — date — NOT NULL
  • M_SECESSIONDATE — date
  • M_EMAILCHECK — varchar2(100)

QUESTION

  • Q_EMAIL — varchar2(50) — Primary key — NOT NULL
  • Q_TITLE — varchar2(100) — NOT NULL
  • Q_CONTENT — varchar2(1000) — NOT NULL

REGISTRATION_DB

  • R_REGISTRATION — varchar2(30) — NOT NULL
  • R_NAME — varchar2(30) — NOT NULL
  • R_DATE — date — NOT NULL
  • R_ANIMALNAME — varchar2(30) — NOT NULL
  • R_AGE — varchar2(30) — NOT NULL
  • R_GENDER — varchar2(10) — NOT NULL
  • R_NEUTRALIZATION — varchar2(10) — NOT NULL

REPORT

  • R_NO — varchar2(10) — Primary key — NOT NULL
  • R_TITLE — varchar2(50) — NOT NULL
  • R_ID — varchar2(30) — NOT NULL
  • R_REPORTED_ID — varchar2(30) — NOT NULL
  • R_EMAIL — varchar2(50) — NOT NULL
  • R_DATE — date

REPORT_HISTORY

  • RH_ID — varchar2(30) — Primary key — NOT NULL
  • RH_EMAIL — varchar2(50) — NOT NULL
  • RH_COUNT — varchar2(10)
  • RH_DATE — date
  • RH_RELEASE_DATE — date

Untitled

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • M_ID — varchar2(50) — Foreign key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)

Untitled2

  • M_ID — varchar2(50) — Foreign key → Untitled.M_ID — NOT NULL
  • PID — number — Foreign key → CopyOfPARCELOUT.PID — NOT NULL
  • Field — VARCHAR(255)

Untitled3

  • Key — number — Primary key — NOT NULL
  • Field — number
  • Field2 — varchar2(100)
  • Field3 — varchar2(50)
  • Field4 — varchar2(1000)
  • Field5 — date