big9teampjt-03
Tables (11)
admin (Untitled3)
- admin_id (Key) — int — Primary key — NOT NULL
- username (Field) — varchar(100)
- password (Field2) — varchar(50)
board_counsel (Untitled4)
- counsel_id (Key) — long — Primary key — NOT NULL
- member_id (long) — long — Foreign key → member.member_id — NOT NULL
- title (Field) — varchar(100)
- username (Field6) — varchar(100)
- content (Field7) — varchar(1000)
- regdate (Field2) — date
- hitcount (Field3) — int
- replycnt (Field5) — int
- secret (Field4) — int or char
- counselimage (Field8) — varchar(100)
- like (Field9) — int
- Field10
board_docsearch (Untitled5)
- docsearch_id (Key) — long — Primary key — NOT NULL
- doctor_id (Key2) — long — Foreign key → doctor.doctor_id — NOT NULL
- map (Field) — api
board_petstory (Untitled7)
- petstory_id (Key) — int — Primary key — NOT NULL
- member_id (long) — long — Foreign key → member.member_id — NOT NULL
- doctor_id (Key2) — long — Foreign key → doctor.doctor_id — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — varchar(500)
- petstoryimage (Field3) — varchar(100)
- regdate (Field4) — date
- hitcount (Field5) — int
- replycnt (Field6) — int
- like (Field7) — int
- username (Field8) — varchar(50)
- Field9
board_question (Untitled8)
- question_id (Key) — int — Primary key — NOT NULL
- member_id (long) — long — Foreign key → member.member_id — NOT NULL
- doctor_id (Key2) — long — Foreign key → doctor.doctor_id — NOT NULL
- admin_id (Key3) — int — Foreign key → admin.admin_id — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — varchar(500)
- questionimage (Field3) — varchar(100)
- regdate (Field4) — date
- hitcount (Field5) — int
- replycnt (Field6) — int
- like (Field7) — int
- username (Field8) — varchar(50)
- Field9
comment_counsel (CopyOfCopyOfCopyOfUntitled7)
- comcounsel_id (Key) — int — Primary key — NOT NULL
- counsel_id (Key2) — long — Foreign key → board_counsel.counsel_id — NOT NULL
- doctor_id (Key3) — long — Foreign key → doctor.doctor_id — NOT NULL
- bcounselnum (Field) — int
- grp(댓글이 속한 댓글 번호) (Field2) — int
- grps(대댓글 순서) (Field3) — int
- grpl(댓글의 깊이) (Field4) — int
- username (Field5) — varchar(50)
- content (Field6) — varchar(500)
- regdate (Field7) — date
comment_petstory (CopyOfUntitled7)
- competstory_id (Key) — int — Primary key — NOT NULL
- petstory_id (Key2) — int — Foreign key → board_petstory.petstory_id — NOT NULL
- member_id (long) — long — Foreign key → board_petstory.member_id — NOT NULL
- doctor_id (Key22) — long — Foreign key → board_petstory.doctor_id — NOT NULL
- bpetstorynum (Field) — int
- grp(댓글이 속한 댓글 번호) (Field2) — int
- grps(대댓글 순서) (Field3) — int
- grpl(댓글의 깊이) (Field4) — int
- username (Field5) — varchar(50)
- content (Field6) — varchar(500)
- regdate (Field7) — date
comment_question (CopyOfCopyOfUntitled7)
- comquestion_id (Key) — int — Primary key — NOT NULL
- question_id (Key2) — int — Foreign key → board_question.question_id — NOT NULL
- member_id (long) — long — Foreign key → board_question.member_id — NOT NULL
- doctor_id (Key22) — long — Foreign key → board_question.doctor_id — NOT NULL
- admin_id (Key3) — int — Foreign key → board_question.admin_id — NOT NULL
- bquestionnum (Field) — int
- grp(댓글이 속한 댓글 번호) (Field2) — int
- grps(대댓글 순서) (Field3) — int
- grpl(댓글의 깊이) (Field4) — int
- username (Field5) — varchar(50)
- content (Field6) — varchar(500)
- regdate (Field7) — date
doctor (Untitled2)
- doctor_id (Key) — long — Primary key — NOT NULL
- username (Field) — varchar(100)
- password (Field2) — varchar(50)
- doccareer (Field12) — varchar(100)
- doclicensenum (Field3) — varchar(50)
- dochospital (Field4) — varchar(50)
- dochospitaltel (Field5) — varchar(50)
- dochospitaladdr (Field6) — varchar(50)
- dochospitalpostal (Field7) — varchar(50)
- licenseimage (Field8) — varchar(100)
- profileimage (Field9) — varchar(100)
- approval (Field10) — boolean
- approvaldate (Field11) — date
- Field13
member (Untitled)
- member_id (long) — long — Primary key — NOT NULL
- username (Field) — varchar(100)
- password (varchar(50)) — varchar(50)
- phone (Field3) — varchar(50)
pet (CopyOfUntitled)
- pet_id (long) — long — Primary key — NOT NULL
- member_id (long2) — long — Foreign key → member.member_id — NOT NULL
- petbirth (Field4) — varchar(50)
- petname (Field5) — varchar(50)
- petgender (Field6) — varchar(50)
- petbreed (Field2) — varchar(50)
- petweight (Field7) — varchar(50)
- petimage (Field8) — varchar(100)
- petneutering (Field) — boolean
- petvaccination (Field3) — boolean