cafecommercial _team_project

Tables (4)

Untitled3

  • Key — Primary key — NOT NULL
  • Field

cafe (Untitled2)

  • cafe_id (Key) — null — Primary key — NOT NULL
  • name (Field) — notnull
  • addr (Field2) — notnull
  • biz_code (Field3) — notnull
  • latitude (Field4) — not null
  • longitude (Field5) — notnull
  • rp_key (FK) — null

cafe_review (Untitled)

  • review_id (Key) — null — Primary key — NOT NULL
  • Field

cafe_sales (cage_sales)

  • sales_id (key) — null — Primary key — NOT NULL
  • date (Field) — notnull
  • price (Field2) — not null
  • visitor_count (Field3) — null
  • cafe_id (FK) — not null
  • sales (Field4) — not null