ddd
테이블 (5)
Users (Untitled)
- user_email (Key) — VARCHAR2(1000) — 기본 키 — NOT NULL
- user_pw (Field) — VARCHAR2(50)
- user_name (Field2) — VARCHAR2(50)
- user_nick (Field4) — VARCHAR2(50)
부산 테이블 (Untitled2)
- place_id (Key) — INT — 기본 키 — NOT NULL
- place_tag (Field) — VARCHAR2(50)
- place_name (Field2) — VARCHAR2(50)
- location (Field3) — VARCHAR2(50)
- latitude (Field4) — INT
- longtitude (Field5) — INT
- place_img (Field6) — VARCHAR2(5000)
- place_url (Field7) — VARCHAR2(5000)
- place_comment (Field8) — VARCHAR2(5000)
- place_contact (Field9) — VARCHAR2(5000)
- address (Field10) — VARCHAR2(5000)
사용자여행목록 (CopyOfUntitled)
- travel_list (Key2) — VARCHAR2(1000) — 기본 키 — NOT NULL
- user_email (Key) — VARCHAR2(1000) — 외래 키 → Users.user_email — NOT NULL
- place_id (Key3) — INT — 외래 키 → 양양 테이블.place_id — NOT NULL
- place_id (Key4) — INT — 외래 키 → 여수 테이블.place_id — NOT NULL
- place_id (Key5) — INT — 외래 키 → 부산 테이블.place_id — NOT NULL
- schedule_index (Field2) — number(38,0)
- list index (Field3) — number(3,0)
양양 테이블 (CopyOfUntitled22)
- place_id (Key) — INT — 기본 키 — NOT NULL
- place_tag (Field) — VARCHAR2(50)
- place_name (Field2) — VARCHAR2(50)
- location (Field3) — VARCHAR2(50)
- latitude (Field4) — INT
- longtitude (Field5) — INT
- place_img (Field6) — VARCHAR2(5000)
- place_url (Field7) — VARCHAR2(5000)
- place_comment (Field8) — VARCHAR2(5000)
- place_contact (Field9) — VARCHAR2(5000)
- address (Field10) — VARCHAR2(5000)
여수 테이블 (CopyOfUntitled2)
- place_id (Key) — INT — 기본 키 — NOT NULL
- place_tag (Field) — VARCHAR2(50)
- place_name (Field2) — VARCHAR2(50)
- location (Field3) — VARCHAR2(50)
- latitude (Field4) — INT
- longtitude (Field5) — INT
- place_img (Field6) — VARCHAR2(5000)
- place_url (Field7) — VARCHAR2(5000)
- place_comment (Field8) — VARCHAR2(5000)
- place_contact (Field9) — VARCHAR2(5000)
- address (Field10) — VARCHAR2(5000)