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