SNS Petstagram
Tables (7)
BoardDAO (PetstagramBoard)
- public (insertBoard) — void
- public (getBoard) — BoardVO
- public (getBoardList) — List<BoardVO>
- public (getBoardListWriter) — List<BoardVO>
- public (getBoardListMemid) — List<BoardVO>
- public (updateBoard) — void
- public (deleteBoard) — void
- public (insertReply) — boolean
- public (deleteReply) — boolean
FollowDAO (PetstagramFollow)
- public (insertFollow) — void
- public (checkFollow) — int
- public (deleteFollow) — void
- public (getFollowList) — List<FollowVO>
- public (getFollowerList) — List<FollowVO>
MemberDAO (PetstagramMember)
- public (insertMember) — void
- public (getMember) — MemberVO
- public (getMemberList) — List<MemberVO>
- public (updateMember) — void
- public (deleteMember) — void
Petstagram (Member)
- Key (memId) — varchar(50) — Primary key — NOT NULL
- Field (memPw) — Varchar(50)
- Field2 (memNickname) — varchar(50)
- Field3 (memPic) — varchar(200)
- Field4 (memfollowee) — int default 0
- Field5 (memfollower) — int default 0
Petstagram (Board)
- Key (bid) — int — Primary key — NOT NULL
- Field (memId) — varchar(50) not null
- Field2 (pic) — varchar(300) not null
- Field3 (writer) — varchar(100)not null
- Field4 (content) — varchar(200)not null
- Field5 (rpcnt) — int default 0
- Field (bdate) — timestamp default sysdate
Petstagram (Follow)
- Key (fid) — int — Primary key — NOT NULL
- Key (memId) — varchar(50) — Foreign key → Petstagram.Key — NOT NULL
- Field (follower) — int default 0
- Field2 (followee) — varchar(50) not null
- Key (foreign key(follower)) — on delete cascade — NOT NULL
- Field (foreignkey(followee)) — on delete cascade
Petstagram (Reply)
- Key (rid) — int — Primary key — NOT NULL
- Key (bid) — int not null — Foreign key → Petstagram.Key — NOT NULL
- Field2 (memNickname) — varchar(50) not null
- Field3 (msg) — varchar(200) not null
- Field4 (rdate) — timestamp default sysdate
- Field5 (foreignkey(bid)) — on delete cascade