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