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)