team

Tables (7)

Convenience (편의점정보)

  • ConvenienceName (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Location (Field) — VARCHAR(100)

ProductInfo (상품정보)

  • ProductName (Key) — VARCHAR(20) — Primary key — NOT NULL
  • ProductPrice (Field2) — NUMBER
  • ConvenienceName (Key2) — VARCHAR(20) — Foreign key → Convenience.ConvenienceName — NOT NULL

ProductList (상품목록)

  • ProductName (Key) — VARCHAR(20) — Foreign key → ProductInfo.ProductName — NOT NULL
  • Review (Field) — VARCHAR(1000) — Foreign key → Review.Review
  • Recipe (Field2) — VARCHAR(1000) — Foreign key → Recipe.Recipe
  • Reply (Field22) — VARCHAR(500) — Foreign key → Review.Reply

Recipe (레시피)

  • Recipe (Field) — VARCHAR(1000) — Primary key
  • ID (Key) — VARCHAR(20) — Foreign key → UserInfo.ID — NOT NULL
  • Reply (Field2) — VARCHAR(500) — Foreign key → Reply.Reply

Reply (댓글)

  • Reply (Field) — VARCHAR(500) — Primary key
  • ID (Key) — VARCHAR(20) — Foreign key → UserInfo.ID — NOT NULL

Review (리뷰)

  • Review (Field) — VARCHAR(1000) — Primary key
  • ID (Key) — VARCHAR(20) — Foreign key → UserInfo.ID — NOT NULL
  • Reply (Field2) — VARCHAR(500) — Foreign key → Reply.Reply

UserInfo (유저정보)

  • ID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Name (Field) — VARCHAR(20)
  • NickName (Field2) — VARCHAR(20)
  • PW (Key2) — VARCHAR(20) — NOT NULL