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)