SubPJT2

Tables (14)

adoption

  • adoptionno — int
  • uid — varchar(20) — Foreign key → user.uid
  • name — varchar(20) — NOT NULL
  • email — varchar(30) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • job — varchar(30)
  • marriaged — int(11) — NOT NULL
  • sex — int(11) — NOT NULL
  • mid — varchar(20) — Foreign key → manager.mid
  • nation — varchar(20)
  • sido — varchar(20)
  • gugun — varchar(20)
  • place — varchar(20)
  • beforeover — tinyint(1)
  • beforeadopt — tinyint(1)
  • presentanimal — int(11)
  • familyunder — int(11)
  • familymiddle — int(11)
  • familyagree — tinyint(1)
  • dissolution — int(11)
  • sickness — tinyint(1)
  • alone — int(11)
  • temp — varchar(20)
  • house — varchar(20)
  • eatmoney — int(11)
  • caremoney — int(11)
  • reason — varchar(100)
  • think — varchar(100)
  • desertionNo — varchar(20) — Foreign key → careboard.desertionNo
  • fixdate — varchar(20)
  • fixtime — varchar(20)

care

  • carenm — varchar(50) — Primary key — NOT NULL

careboard

  • desertionNo — varchar(20) — Primary key — NOT NULL
  • age — varchar(30)
  • careAddr — varchar(200)
  • careNm — varchar(50) — Foreign key → care.carenm
  • careTel — varchar(14)
  • chargeNm — varchar(20)
  • colorCd — varchar(30)
  • filename — varchar(100)
  • happenDt — varchar(8)
  • happenPlace — varchar(100)
  • kindCd — varchar(50)
  • neuterYn — varchar(1)
  • noticeEdt — varchar(8)
  • noticeNo — varchar(30)
  • noticeSdt — varchar(8)
  • officetel — varchar(14)
  • orgNm — varchar(50)
  • popfile — varchar(100)
  • processState — varchar(10)
  • sexCd — varchar(1)
  • specialMark — varchar(200)
  • weight — varchar(30)

comment

  • commentno — int(11) — Primary key — NOT NULL
  • postscriptno — int(11) — Foreign key → postscript.postscriptno
  • uid — varchar(20) — Foreign key → user.uid
  • content — varchar(3000)
  • createdate — date

interest

  • interestno — int(11)
  • uid — varchar(20) — Foreign key → user.uid
  • desertionNo — varchar(20) — Foreign key → careboard.desertionNo

lost

  • lostno — int
  • losttype — varchar(20)
  • lostbreed — varchar(20)
  • lostsex — varchar(20)
  • lostage — varchar(20)
  • lostdate — varchar(50)
  • lostsido — varchar(20)
  • lostgugun — varchar(20)
  • lostplace — varchar(30)
  • lostcontent — varchar(100)
  • losttagtext — varchar(100)
  • lostphone — varchar(20)
  • lostcreatedate — date
  • lostpic1 — varchar(50)
  • lostpic2 — varchar(50)
  • lostpic3 — varchar(50)
  • uid — varchar(20) — Foreign key → user.uid — NOT NULL

lostreply

  • lostreplyno — int
  • lostno — int(11) — Foreign key → lost.lostno
  • lostreplycontent — varchar(100)
  • createdate — date
  • uid — varchar(20) — Foreign key → user.uid

losttag

  • tagno — int
  • lostno — int(11) — Foreign key → lost.lostno
  • tagname — varchar(30)
  • flag — int(11)

manager

  • mid — varchar(20) — Foreign key → care.carenm — NOT NULL
  • name — varchar(20) — NOT NULL
  • password — varchar(20) — NOT NULL
  • email — varchar(30)
  • phone — varchar(20)
  • createdate — DATE

postpic

  • postpicno — int
  • postscriptno — int — Foreign key → postscript.postscriptno
  • postpath — varchar(50)

postscript

  • postscriptno — int(11)
  • uid — varchar(20)
  • title — varchar(50)
  • content — varchar(3000)
  • image — varchar(100)
  • sido — varchar(20)
  • gugun — varchar(20)
  • kind — varchar(20)
  • createdate — date

postscriptgood

  • postscriptgoodno — int(11)
  • postscriptno — int(11) — Foreign key → postscript.postscriptno
  • uid — varchar(20) — Foreign key → user.uid

survey

  • uid — VARCHAR(20) — Foreign key → user.uid — NOT NULL
  • name — VARCHAR(20)
  • email — VARCHAR(30)
  • phone — VARCHAR(20)
  • job — VARCHAR(30)
  • marriaged — INT(11)
  • sex — INT(11)
  • birthdate — DATE
  • nation — VARCHAR(20)
  • sido — VARCHAR(20)
  • gugun — VARCHAR(20)
  • place — VARCHAR(20)
  • beforeover — INT(11)
  • beforeadopt — INT(11)
  • presentanimal — INT(11)
  • familyunder — INT(11)
  • familymiddle — INT(11)
  • familyagree — INT(11)
  • dissolution — INT(11)
  • sickness — INT(11)
  • alone — INT(11)
  • temp — VARCHAR(20)
  • house — VARCHAR(20)
  • eatmoney — INT(11)
  • caremoney — INT(11)
  • reason — VARCHAR(100)
  • think — VARCHAR(100)

user

  • uid — varchar(20) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • password — varchar(20) — NOT NULL
  • email — varchar(30) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • createdate — date
  • job — varchar(30)
  • marriaged — int(1) — NOT NULL
  • sex — int(1) — NOT NULL
  • birthdate — date
  • flag — int