ㅁㄴㅇㄹ

Tables (13)

board

  • boardNo — number — Primary key — NOT NULL
  • boardTitle — varchar2(100)
  • content — varchar2(3000)
  • write_date — date
  • userNo — number — Foreign key → user.userNo — NOT NULL
  • boardTypeNo — number — Foreign key → boardType.boardTypeNo — NOT NULL

boardType

  • boardTypeNo — number — Primary key — NOT NULL
  • boardType — varchar2(50)

buy

  • userNo — number — Foreign key → user.userNo — NOT NULL
  • objectNo — number — Foreign key → shop.objectNo — NOT NULL

comment

  • commentNo — number — Primary key — NOT NULL
  • comment — varchar2(3000) — archar2(3000) NUL
  • write_date — date
  • boardNo — number — Foreign key → board.boardNo — NOT NULL
  • userNo — number — Foreign key → user.userNo — NOT NULL

file

  • fileNo — number — Primary key — NOT NULL
  • boardNo — number — Foreign key → board.boardNo — NOT NULL
  • originname — varchar2(3000)
  • storedname — varchar2(3000)
  • fileSize — number

message

  • messageNo — number — Primary key — NOT NULL
  • content — varchar2(3000)
  • send_date — date
  • receiveuserNo — number — Foreign key → user.userNo — NOT NULL
  • senduserNo — number — Foreign key → user.userNo — NOT NULL

notice

  • noticeNo — number — Primary key — NOT NULL
  • noticeTitle — varchar2(100)
  • noticeContent — varchar2(3000)
  • noticeWriteDate — date
  • userNo — number — Foreign key → user.userNo — NOT NULL
  • boardTypeNo — number — Foreign key → boardType.boardTypeNo — NOT NULL

pet

  • petNo — number — Primary key — NOT NULL
  • petName — varchar2(50)
  • type — varchar2(50)
  • userNo — number — Foreign key → user.userNo — NOT NULL

position

  • positionNo — number — Primary key — NOT NULL
  • hospital — varchar2(50)
  • normal — varchar2(50)
  • admin — varchar2(50)

reportBoard

  • reportNo — number — Primary key — NOT NULL
  • report_date — date
  • userNo — number — Foreign key → user.userNo — NOT NULL
  • boardNo — number — Foreign key → board.boardNo — NOT NULL

reportComment

  • reportNo — number — Primary key — NOT NULL
  • report_date — date
  • userNo — number — Foreign key → user.userNo — NOT NULL
  • commentNo — number — Foreign key → comment.commentNo — NOT NULL

shop

  • objectNo — number — Primary key — NOT NULL
  • name — varchar2(50)
  • price — number

user

  • userNo — number — Primary key — NOT NULL
  • userName — varchar2(50)
  • userId — varchar2(50)
  • userpw — varchar2(50)
  • email — varchar2(50)
  • address — varchar2(100)
  • phone — varchar2(50)
  • positionNo — number — Foreign key → position.positionNo — NOT NULL