ㅎㅎㅎㅎ
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