편의점

테이블 (5)

Discount (Untitled5)

  • discount_id (PK) — int — 기본 키 — NOT NULL
  • item_id (FK) — int — 기본 키 — NOT NULL
  • event (Field) — enum
  • percent (Field2) — int
  • Field3

Item (Untitled4)

  • item_id (PK) — int — 기본 키 — NOT NULL
  • store_id (FK) — int — 기본 키 — NOT NULL
  • type (Field) — enum
  • name (Field2) — String
  • comment (Field3) — String
  • like (Field4) — int
  • Field5

Liked_Item (Untitled3)

  • id (PK) — int — 기본 키 — NOT NULL
  • item_id (FK) — int — 기본 키 — NOT NULL
  • item_id (asd) — int
  • Field

Store (Untitled2)

  • store_id (PK) — int — 기본 키 — NOT NULL
  • latitude (Field) — double
  • longitude (Field2) — double
  • name (Field3) — String
  • like (Field4) — int
  • Field5

User (Untitled)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • password (Field) — int
  • address (Field2) — String
  • email (Field3) — String
  • latitude (Field4) — double
  • longitude (Field5) — double