Jamping
Tables (21)
camp_site
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- link — VARCHAR(1000)
- region_code — VARCHAR(30) — NOT NULL
- district_code — VARCHAR(50) — NOT NULL
- check_in_time — TIME — NOT NULL
- check_out_time — TIME — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- camp_site_id — BIGINT — Foreign key → camp_site.id
- reservation_sites — VARCHAR(255) — NOT NULL
- camping_start_date — DATE
- camping_end_date — DATE
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_expense
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- payer_id — BIGINT — Foreign key → camping_fam_member.id — NOT NULL
- amount — DECIMAL(12, 0) — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_invitation
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- inviter_id — BIGINT — Foreign key → camping_fam_member.id — NOT NULL
- email — VARCHAR(100) — NOT NULL
- invited_user_id — BIGINT — Foreign key → user.id
- token — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING | ACCEPTED | REJECTED | EXPIRED
- expired_at — DATETIME — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_member
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- role — VARCHAR(20) — NOT NULL — LEADER | MEMBER
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_menu
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- camping_date — DATE — NOT NULL
- meal_type — VARCHAR(20) — NOT NULL — BREAKFAST | LUNCH | DINNER
- menu — VARCHAR(200)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_schedule_temp
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- user_id — BIGINT — NOT NULL
- selected_date — DATE — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_settlement
- id — BIGINT — Primary key — NOT NULL
- camping_fam_expense_id — BIGINT — Foreign key → camping_fam_expense.id — NOT NULL
- debtor_member_id — BIGINT — Foreign key → camping_fam_member.id — NOT NULL
- amount — DECIMAL(12, 0) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_shopping_category
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_shopping_item
- id — BIGINT — Primary key — NOT NULL
- camping_fam_shopping_category_id — BIGINT — Foreign key → camping_fam_shopping_category.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- quantity — VARCHAR(50)
- is_purchased — TINYINT(1) — NOT NULL
- memo — VARCHAR(200)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_supply
- id — BIGINT — Primary key — NOT NULL
- camping_fam_id — BIGINT — Foreign key → camping_fam.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
camping_fam_supply_assignment
- id — BIGINT — Primary key — NOT NULL
- camping_fam_supply_id — BIGINT — Foreign key → camping_fam_supply.id — NOT NULL
- camping_fam_member_id — BIGINT — Foreign key → camping_fam_member.id — NOT NULL
- user_gear_id — BIGINT — Foreign key → user_gear.id
- memo — VARCHAR(200)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- memo — VARCHAR(1000)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
gear
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- link — VARCHAR(500)
- image_url — VARCHAR(1000)
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- maker_id — BIGINT — Foreign key → maker.id — NOT NULL
- memo — VARCHAR(1000)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
maker
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- name_eng — VARCHAR(100)
- homepage_url — VARCHAR(500)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT — Primary key — NOT NULL
- receiver_id — BIGINT — Foreign key → user.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- message — VARCHAR(300) — NOT NULL
- reference_id — BIGINT — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
recipe
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- ingredients — TEXT
- instructions — TEXT
- recipe_category_id — BIGINT — Foreign key → recipe_category.id — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
recipe_category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
review
- id — BIGINT — Primary key — NOT NULL
- gear_id — BIGINT — Foreign key → gear.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- rating — INT — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- status — VARCHAR(20) — NOT NULL — ACTIVE | INACTIVE
- moderation_reason — VARCHAR(1000)
- moderated_by — BIGINT — Foreign key → user.id
- moderated_at — DATETIME
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- provider — VARCHAR(20) — NOT NULL — GOOGLE | KAKAO | NAVER
- provider_user_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- role — VARCHAR(20) — NOT NULL — USER | ADMIN
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL
user_gear
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- maker_id — BIGINT — Foreign key → maker.id
- gear_id — BIGINT — Foreign key → gear.id
- name — VARCHAR(100)
- memo — VARCHAR(1000)
- created_by_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_by_id — BIGINT
- updated_at — DATETIME — NOT NULL