capstone

Tables (3)

Abandoned_animal_list_tbl (Untitled2)

  • PK(id) (desertionNo) — VARCHAR — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • 썸네일이미지 (filename) — VARCHAR
  • 접수일 (happenDt) — VARCHAR
  • 발견장소 (happenPlace) — VARCHAR
  • 품종 (kindCd) — VARCHAR
  • 색상 (colorCd) — VARCHAR

Untitled3

  • Key — Primary key — NOT NULL

User (Untitled)

  • PK(id) (id) — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR
  • 닉네임 (nickname) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 가입일 (register_date) — TIMESTAMP
  • 정보업데이트일 (updated_date) — TIMESTAMP