KHProject

Tables (4)

Untitled (DOGINFO)

  • Key (DOG_IDX) — int — Primary key — NOT NULL
  • Field (DOG_NAME) — String
  • Field3 (DOG_SIZE) — int
  • Field4 (DOG_CARE) — int
  • Field5 (DOG_USER_IDX) — int
  • Field6 (DOG_PHOTO_NAME) — int
  • Field (DOG_AGE) — int

Untitled (REVIEW)

  • Key (REVIEW_IDX) — int — Primary key — NOT NULL
  • Field (REVIEW_USER_IDX) — int
  • Field2 (REVIEW_SITTER_IDX) — int
  • Field3 (REVIEW_CITY) — String
  • Field4 (REVIEW_SERVICE) — String
  • Field5 (REVIEW_STAR) — int
  • Field6 (REVIEW_REGDATE) — DATE
  • Field7 (REVIEW_USER_NAME) — String
  • Field (REVIEW_SITTER_NAME) — String
  • Field (REVIEW_TITLE) — String
  • Field (REVIEW_CONTENT) — Yes
  • Field (REVIEW_PHOTO_NAME) — int

Untitled (NOTICE)

  • Key (NOTICE_IDX) — int — Primary key — NOT NULL
  • Field (NOTICE_TITLE) — String
  • Field (NOTICE_NAME) — String
  • Field (NOTICE_CONTENT) — Yes
  • Field (NOTICE_PWD) — String
  • Field (NOTICE_READHIT) — int
  • Field (NOTICE_DEL_INFO) — int
  • Field (NOTICE_REGDATE) — DATE

Untitled2 (INQUIRY)

  • Key (INQUIRY_IDX) — int — Primary key — NOT NULL
  • Field (INQUIRY_QUESTION) — Yes
  • Field (INQUIRY_ANSWER) — Yes
  • Field (INQUIRY_CODE) — int