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