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