finalProject

Tables (13)

CommentLike (Untitled6)

  • likeNo (Key2) — Long — Primary key — NOT NULL
  • commentNo (Key) — Long — Foreign key → comment.commentNo — NOT NULL
  • memberId (Field) — String
  • regDate (Field2) — Date

CommentReply (Untitled11)

  • replyNo (Key2) — Long — Primary key — NOT NULL
  • commentNo (Key) — Long — Foreign key → comment.commentNo — NOT NULL
  • content (Field) — String
  • isDeleted (Field2) — int
  • memberId (Field3) — String
  • regDate (Field4) — Date
  • Field5

CommentReport (Untitled10)

  • reportNo (Key2) — String — Primary key — NOT NULL
  • commentNo (Key) — Long — Foreign key → comment.commentNo — NOT NULL
  • memberId (Field) — String
  • regDate (Field2) — Date

LikeBoard (Untitled8)

  • rowNo (Key) — Long — Primary key — NOT NULL
  • memberNo (Key2) — Long — Foreign key → member.memberNo — NOT NULL
  • boardNo (Field) — long
  • Field2

administrator (Untitled2)

  • rowNo (Key) — Long — Primary key — NOT NULL
  • memberNo (Key2) — Long — Foreign key → member.memberNo — NOT NULL
  • auth (Field) — String

board (Untitled5)

  • boardNo (Key) — Long — Primary key — NOT NULL
  • bad (Field) — int
  • category (Field2) — String
  • content (Field3) — String
  • createDate (Field4) — Date
  • good (Field5) — String
  • LastModifiedDate (Field6) — String
  • memberId (Field7) — String
  • report (Field8) — String
  • title (Field9) — String
  • viewcount (Field10) — int
  • img (Field11) — String
  • Field12

comment (Untitled9)

  • commentNo (Key) — Long — Primary key — NOT NULL
  • boardNo (Key2) — Long — Foreign key → board.boardNo — NOT NULL
  • content (Field) — String
  • idDeleted (Field2) — int
  • memberId (Field3) — String
  • regDate (Field4) — Date
  • upDate (Field5) — Date

hateBoard (Untitled7)

  • rowNo (Key2) — Long — Primary key — NOT NULL
  • memberNo (Key) — Long — Foreign key → member.memberNo — NOT NULL
  • boardNo (Field) — Long

member (Untitled)

  • memberNo (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • LastModifiedDate (Field2) — Date
  • memberBirthDay (Field3) — Date
  • memberCar (Field4) — String
  • memberId (Field5) — String
  • memberPw (Field6) — String
  • name (Field7) — String
  • regDate (Field8) — Date
  • status (Field9) — String

myChargingState (Untitled3)

  • rowNo (Key2) — Long — Primary key — NOT NULL
  • memberNo (Key) — Long — Foreign key → member.memberNo — NOT NULL
  • addr (Field) — String
  • busiCall (Field2) — String
  • chgerType (Field3) — String
  • lat (Field4) — String
  • lng (Field5) — String
  • statNm (Field6) — String
  • useTime (Field7) — String

myInterestingCar (Untitled13)

  • myInterestingCarNo (Key) — Long — Primary key — NOT NULL
  • memberNo (Key2) — Long — Foreign key → member.memberNo — NOT NULL
  • Field — String

myParkingState (Untitled4)

  • rowNo (Key2) — Long — Primary key — NOT NULL
  • memberNo (Key) — Long — Foreign key → member.memberNo — NOT NULL
  • parkingType (Field) — String
  • addpayUnit (Field2) — String
  • addr1 (Field3) — String
  • addr2 (Field4) — String
  • addtimeUnit (Field5) — String
  • adminiNm (Field6) — String
  • basicsPay (Field7) — String
  • basicsTime (Field8) — String
  • call (Field9) — String
  • holiend (Field10) — String
  • holiStart (Field11) — String
  • kind1 (Field12) — String
  • lat (Field13) — String
  • lng (Field14) — String
  • monthPay (Field15) — String
  • operatingDay (Field16) — String
  • parkingNm (Field17) — String
  • parkingNum (Field18) — String
  • paymethod (Field19) — String
  • satENd (Field20) — String
  • satStart (Field21) — String
  • weekStart (Field22) — String
  • weeEnd (Field23) — String
  • Field24

notice (Untitled12)

  • noticeNo (Key) — Long — Primary key — NOT NULL
  • category (Field) — String
  • content (Field2) — String
  • createDate (Field3) — String
  • img (Field4) — String
  • LastModifiedDate (Field5) — String
  • memberId (Field6) — String
  • title (Field7) — String
  • viewcount (Field8) — String