foodfood
Tables (5)
Comments (Comment)
- commentId (Key) — Long — Primary key — NOT NULL
- storeId (Key2) — Foreign key → Detail.storeId — NOT NULL
- comment (Field)
- nickname (Field2)
- storeId (Field3)
- Field4
Detail
- storeId (Key) — Primary key — NOT NULL
- image (Field)
- title (Field2)
- regionName (Field3)
- address (Field4)
- phone (Field5)
- comments (Field6)
Regions (Region)
- regionId (Key) — Long — Primary key — NOT NULL
- regionName (Field)
- storeId (Field2)
Store
- StoreId (Key) — Long — Primary key — NOT NULL
- image (Field) — url
- title (Field2) — String
- like (Field3) — int
- commentCnt (Field4) — int
- regionName (Field5)
User
- userId (Key) — Long — Primary key — NOT NULL
- pwd (Field)
- nickname (Field2)