gyungsa

Tables (6)

Place (가게)

  • lat (Key) — Primary key — NOT NULL
  • lng (Key2) — Primary key — NOT NULL
  • name (Key3) — varchar2(20) — Primary key — NOT NULL
  • address (Field2) — varchar2(50) — NOT NULL
  • time (Field3) — NOT NULL
  • phoneNumber (Field4)
  • category (Field5) — NOT NULL
  • floor (Field6) — int — NOT NULL
  • runway (Field7) — boolean — NOT NULL
  • email (Key4) — Foreign key → user.email — NOT NULL
  • createdAt (Field) — NOT NULL
  • updatedAt (Field8) — NOT NULL

bookmark (즐겨찾기)

  • email (Key) — Foreign key → user.email — NOT NULL
  • lat (Key2) — int — Foreign key → Place.lat — NOT NULL
  • lng (Key22) — int — Foreign key → Place.lng — NOT NULL
  • name (Key3) — varchar2(20) — Foreign key → Place.name — NOT NULL

image (이미지)

  • fileURL (Key) — Primary key — NOT NULL
  • lat (Key2) — Foreign key → review.lat — NOT NULL
  • lng (Key22) — Foreign key → review.lng — NOT NULL
  • name (Key3) — Foreign key → review.name — NOT NULL
  • email (Key4) — Foreign key → review.email — NOT NULL
  • fileSize (Field) — NOT NULL
  • createdAt (Field2) — NOT NULL
  • Key2 (Key222) — Foreign key — NOT NULL

review (가게 리뷰)

  • lat (Key) — Foreign key → Place.lat — NOT NULL
  • lng (Key2) — Foreign key → Place.lng — NOT NULL
  • name (Key3) — Foreign key → Place.name — NOT NULL
  • email (Key4) — Foreign key → user.email — NOT NULL
  • floors (Field)
  • runway (Field2)
  • time (Field3)
  • isConvenient (Field4) — NOT NULL
  • content (Field5)
  • createdAt (Field6)
  • updatedAt (Field7)

space (공간(도로, 길))

  • lat (Key) — Primary key — NOT NULL
  • lng (Key2) — Primary key — NOT NULL
  • email (Key3) — Foreign key → user.email — NOT NULL
  • content (Field) — NOT NULL
  • address (Field2) — NOT NULL
  • createdAt (Field3) — NOT NULL
  • updatedAt (Field4) — NOT NULL

user (유저)

  • email (Key) — varchar2(100) — Primary key — NOT NULL
  • password (Field) — varchar2(100) — NOT NULL
  • nickname (Field2) — varchar2(10) — NOT NULL
  • isDisadvantaged (Field3) — boolean — NOT NULL
  • isConsentPolicy (Field4) — boolean — NOT NULL
  • point (Field5) — int — NOT NULL
  • createdAt (Field6) — NOT NULL
  • updatedAt (Field7) — NOT NULL