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