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