planit

Tables (4)

RECOMMEND (Untitled3)

  • REVIEW_PK (review_pk) — VARCHAR2 — Primary key — NOT NULL
  • COMMENT (comment) — VARCHAR2
  • GRADE (grade) — FLOAT
  • IDFK (id2) — VARCHAR2 — Foreign key → USER.ID — NOT NULL

RECOMMEND (Untitled4)

  • RECOMMENDPK (recommend_pk) — VARCHAR2 — Primary key — NOT NULL
  • AGE (age) — VARCHAR2
  • SEASON (season) — VARCHAR2
  • EXPERIENCE (experience) — VARCHAR2
  • ENVIRONMENT (environment) — VARCHAR2
  • ACTIVITY (activity) — VARCHAR2
  • RCUSERFK (id) — VARCHAR2 — Foreign key → USER.ID — NOT NULL

TRAVEL_PLANS (Untitled2)

  • TRAVELPK (travel_pk) — VARCHAR2 — Primary key — NOT NULL
  • AREA (area) — VARCHAR2
  • DATE (date) — VARCHAR2
  • STORENAME (storename) — VARCHAR2
  • LINK (link) — VARCHAR2
  • SEARCH (search) — VARCHAR2
  • STOREADDS (storeadds) — VARCHAR2
  • MAPX (mapx) — NUMBER
  • MAPY (mapy) — NUMBER

USER (Untitled)

  • ID (id) — VARCHAR2 — Primary key — NOT NULL
  • PW (pw) — VARCHAR2
  • EMAIL (email) — VARCHAR2
  • SOCIALNUMBER (social_nm) — VARCHAR2
  • ADDRESS (addr) — VARCHAR2