ㅎㅎㅎㅎ

Tables (8)

expense_book

  • ebid — BIGINT
  • pid — BIGINT — Foreign key → planner.pid — NOT NULL
  • total_budget — INT — NOT NULL
  • total_expenses — INT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

expense_item

  • emid — BIGINT
  • ebid — BIGINT — Foreign key → expense_book.ebid — NOT NULL
  • ppid — BIGINT — Foreign key → planner_place.ppid — NOT NULL
  • who — VARCHAR(20)
  • whopay — VARCHAR(20)
  • content — TEXT — NOT NULL
  • expense — INT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

journal

  • jid — BIGINT
  • ppid — BIGINT — Foreign key → planner_place.ppid
  • content — TEXT
  • image_url — TEXT
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

places

  • plid — BIGINT
  • google_place_id — VARCHAR(255) — NOT NULL
  • place_name — VARCHAR(100) — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

planner

  • pid — BIGINT
  • planner_name — VARCHAR(50) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

planner_place

  • ppid — BIGINT
  • pid — BIGINT — Foreign key → planner.pid — NOT NULL
  • plid — BIGINT — Foreign key → places.plid — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL

user_planner_join

  • upjid — BIGINT
  • uid — BIGINT — Foreign key → users.uid
  • pid — BIGINT — Foreign key → planner.pid — NOT NULL
  • upj_role — VARCHAR(20) — NOT NULL

users

  • uid — BIGINT
  • user_email — VARCHAR(255) — NOT NULL
  • user_pw — VARCHAR(60) — NOT NULL
  • user_name — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(20)
  • image_url — TEXT
  • user_role — VARCHAR(20) — NOT NULL