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