WeakMap
Tables (8)
BUSINESSHOURS (Untitled6)
- placeID (Key) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
- dayOfWeek (Field) — VARCHAR2(10)
- openTime (Field2) — VARCHAR2(5)
- closeTime (Field4) — VARCHAR2(5)
FAVORITES (Untitled2)
- userID (Key) — VARCHAR2(36) — Foreign key → USERS.userID — NOT NULL
- placeID (Key2) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
IMAGES (Untitled8)
- imageID (Key) — VARCHAR2(36) — Primary key — NOT NULL
- placeID (Key2) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
- imageURL (Field) — VARCHAR2(255) — NOT NULL
- imageOrder (Field2) — NUMBER
PLACEDETAILS (Untitled4)
- placeID (Key) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
- placeFloor (Field) — NUMBER
- isElevator (Field2) — CHAR(1) — Y, N
- isEscalator (Field3) — CHAR(1)
- isDisabilityElevator (Field4) — CHAR(1)
- isEntranceBarrier (Field5) — CHAR(1)
- isSlope (Field6) — CHAR(1)
PLACES (Untitled3)
- placeID (Key) — VARCHAR2(36) — Primary key — NOT NULL
- placeName (Field) — VARCHAR2(255) — NOT NULL
- longtitude (Field2) — NUMBER(9,6) — NOT NULL — 위도
- latitude (Field3) — NUMBER(9,6) — NOT NULL — 경도
- placeAddress (Field4) — VARCHAR2(255) — 한글 주소
- placeContacts (Field5) — VARCHAR2(20)
- placeType (Field6) — VARCHAR2(5) — NOT NULL — 식당, 카페, 공공장소, 병원
- comfortLevel (Field7) — NUMBER — 편해요/불편해요 합계
PLCAEREPORTS (Untitled7)
- reportID (Key) — VARCHAR(36) — Primary key — NOT NULL
- userID (Key2) — VARCHAR2(36) — Foreign key → USERS.userID — NOT NULL
- placeID (Key3) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
- newPlaceAddress (Field) — VARCHAR2(255)
- newPlaceContacts (Field2) — VARCHAR2(20)
- newPlaceType (Field3) — VARCHAR2(5)
- newPlaceFloor (Field4) — NUMBER
- newIsElevator (Field5) — CHAR(1) — Y, N
- newIsEscalator (Field6) — CHAR(1) — Y, N
- newIsDisabilityElevator (Field7) — CHAR(1)
- newIsEntranceBarrier (Field8) — CHAR(1)
- newIsSlope (Field9) — CHAR(1)
- isApproved (Field10) — CHAR(1)
REVIEWS (Untitled5)
- reviewID (Key) — VARCHAR2(36) — Primary key — NOT NULL
- placeID (Key2) — VARCHAR2(36) — Foreign key → PLACES.placeID — NOT NULL
- userID (Key3) — VARCHAR2(36) — Foreign key → USERS.userID — NOT NULL
- reviewTime (Field) — DATE — NOT NULL
- reviewContext (Field2) — CLOB
USERS (Untitled)
- userID (Key) — VARCHAR2(36) — Primary key — NOT NULL
- nickname (Field) — VARCHAR2(255) — NOT NULL
- email (Field2) — VARCHAR2(255) — NOT NULL
- password (Field3) — VARCHAR2(255) — NOT NULL
- isDisability (Field4) — VARCHAR2(10) — NOT NULL — 일반인, 교통약자
- locationCollectAgree (Field5) — CHAR(1) — NOT NULL