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