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