intravel

Tables (7)

map (Untitled4)

  • PK (map_id) — bigint — Primary key — NOT NULL
  • FK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • x좌표 (longitude) — varchar
  • y좌표 (latitude) — varchar
  • 핀이름 (pin_name) — varchar
  • 핀컬러 (pin_color)
  • 핀주소 (address) — varchar

memo (Untitled3)

  • PK (memo_id) — bigint — Primary key — NOT NULL
  • FK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • 제목 (memo_title) — varchar
  • 내용 (memo_content) — varchar
  • 선택날짜 (choice_date) — varchar
  • 생성일 (memo_create_date) — varchar

money (Untitled6)

  • PK (money_id) — bigint — Primary key — NOT NULL
  • PK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • 타이틀 (money_title) — varchar
  • 경비 (expenses) — bigint

pay (Untitled7)

  • PK (payId) — bigint — Primary key — NOT NULL
  • PK (money_id) — bigint — Foreign key → money.PK — NOT NULL
  • PK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • 내용 (pay_title) — varchar
  • 추가금 (plus_amt) — long
  • 지출금 (minus_amt) — long

photo (Untitled5)

  • PK (photo_id) — bigint — Primary key — NOT NULL
  • FK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • 생성날짜 (create_date) — varchar
  • 파일이름 (file_name) — varchar
  • 파일경로 (file_path) — varchar

to_do_list (Untitled2)

  • PK (todo_id) — bigint — Primary key — NOT NULL
  • FK (trav_id) — bigint — Foreign key → travel.PK — NOT NULL
  • 내용 (todo_content) — varchar
  • 완료여부 (todo_complete) — char
  • 중요여부 (todo_impo) — char

travel (Untitled)

  • PK (trav_id) — bigint — Primary key — NOT NULL
  • 제목 (trav_title) — varchar
  • 생성날짜 (create_date) — varchar
  • 시작날짜 (start_date) — varchar
  • 종료날짜 (end_date) — varchar
  • 카테고리 (cate) — String
  • 완료여부 (trav_date) — char