레시피

테이블 (8)

BoardDTO

  • BNum — NUMBER
  • BWriter — VARCHAR2(50)
  • BTitle — VARCHAR2(200)
  • BContent — CLOB
  • BDate — TIMESTAMP
  • BUpdateDate — TIMESTAMP
  • BHit — NUMBER
  • BFileName — VARCHAR2(100)

CartDTO

  • CNum — NUMBER
  • CPNum — NUMBER
  • CId — VARCHAR2(50)
  • Quantity — NUMBER

CommentDTO

  • CNum — NUMBER
  • CBNum — NUMBER
  • CWriter — VARCHAR2(50)
  • CContent — CLOB
  • CDate — TIMESTAMP

ICategoryDTO

  • ICcode — NUMBER
  • ICname — VARCHAR2(100)

MemberDTO

  • MId — VARCHAR2(50)
  • MPw — VARCHAR2(100)
  • MName — VARCHAR2(100)
  • MBirth — VARCHAR2(10)
  • MGender — VARCHAR2(10)
  • MEmail — VARCHAR2(100)
  • MPhone — VARCHAR2(20)
  • MAddr — VARCHAR2(200)
  • MProfileName — VARCHAR2(100)

ProductDTO

  • PNum — NUMBER
  • PName — VARCHAR2(100)
  • PPrice — VARCHAR2(50)
  • PCategory — VARCHAR2(50)
  • PDescription — CLOB
  • PMId — VARCHAR2(50)
  • PStock — NUMBER

RecipesDTO

  • RNum — NUMBER
  • RTitle — VARCHAR2(200)
  • RDescription — CLOB
  • RInstructions — CLOB
  • RCookTime — NUMBER
  • RDifficulty — VARCHAR2(10)
  • RImageFileName — VARCHAR2(100)
  • RCategory — VARCHAR2(50)
  • BRNum — NUMBER

WishDTO

  • WId — VARCHAR2(50)
  • CRDate — TIMESTAMP
  • WMId — VARCHAR2(50)
  • WPNum — NUMBER