ㅁㄴㅇㄹ
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