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