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