1
Tables (8)
board_category
- categoryNo — NUMBER — Primary key — NOT NULL
- categoryName — VARCHAR2(100) — NOT NULL
- categoryDate — DATE — NOT NULL
board_file
- fileNo — NUMBER — Primary key — NOT NULL
- boardNo — NUMBER — NOT NULL
- fileOriginalName — VARCHAR2(500) — NOT NULL
- fileStoredName — VARCHAR2(500) — NOT NULL
- filePath — VARCHAR2(1000) — NOT NULL
board_recipe
- boardNo — NUMBER — Primary key — NOT NULL
- categoryNo — NUMBER — NOT NULL
- userNo — NUMBER — NOT NULL
- boardTitle — VARCHAR2(500) — NOT NULL
- boardContent — VARCHAR2(4000)
- boardInsertDate — DATE — NOT NULL
- boardUpdateDate — DATE — NOT NULL
- boardHit — NUMBER — NOT NULL
- boardLike — NUMBER — NOT NULL
comment
- commentNo — NUMBER — Primary key — NOT NULL
- boardNo — NUMBER — NOT NULL
- userNo — NUMBER — NOT NULL
- commentContent — VARCHAR2(4000) — NOT NULL
- commentInsertDate — DATE — NOT NULL
follow
- followNo — NUMBER — Primary key — NOT NULL
- followUser — NUMBER — NOT NULL
- followerUser — NUMBER — NOT NULL
ingredient
- Key — NUMBER — Primary key — NOT NULL
- boardNo — NUMBER — NOT NULL
profile_image
- imageNo — NUMBER — Primary key — NOT NULL
- userNo — NUMBER — NOT NULL
- imageOriginName — VARCHAR2(500) — NOT NULL
- imageStoredName — VARCHAR2(500) — NOT NULL
- imagePath — VARCHAR2(1000) — NOT NULL
user
- userNo — NUMBER — Primary key — NOT NULL
- userId — VARCHAR2(100) — NOT NULL
- userPw — VARCHAR2(100) — NOT NULL
- userName — VARCHAR2(100)
- userNick — VARCHAR2(100)
- userGender — VARCHAR2(1)
- userEmail — VARCHAR2(100)
- userPhone — VARCHAR2(11)
- userAddress — VARCHAR2(100)
- userIntro — VARCHAR2(1000)