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)