test

Tables (16)

Untitled

    Untitled2

      campground

      • id — long — Primary key — NOT NULL
      • host_id — long — Foreign key → member.id — NOT NULL
      • category_id — VARCHAR(255) — Foreign key → campground_category.id — NOT NULL
      • location_id — VARCHAR(255) — Foreign key → location.id — NOT NULL
      • campground_name — VARCHAR(255)
      • campground_address — VARCHAR(255)
      • address_detail — VARCHAR(255)
      • phone — VARCHAR(255)
      • approve — VARCHAR(255)

      campground_category

      • id — VARCHAR(255) — Primary key — NOT NULL
      • category_name — VARCHAR(255)

      campground_image

      • id — long — Primary key — NOT NULL
      • campground_id — long — Foreign key → campground.id — NOT NULL
      • file_name — VARCHAR(255)
      • save_file_name — VARCHAR(255)
      • iamge_path — VARCHAR(255)
      • image_order — VARCHAR(255)

      campground_option

      • campground_id — long — Foreign key → campground.id — NOT NULL
      • campground_options — VARCHAR(255)

      campsite

      • id — VARCHAR(255) — Primary key — NOT NULL
      • campground_id — long — Foreign key → campground.id — NOT NULL
      • campsite_category — VARCHAR(255) — Foreign key → campsite_category.id — NOT NULL
      • campsite_name — VARCHAR(255)
      • campsite_price — VARCHAR(255)
      • head_count — VARCHAR(255)

      campsite_category

      • id — VARCHAR(255) — Primary key — NOT NULL
      • category_name — VARCHAR(255)

      campsite_image

      • id — long — Primary key — NOT NULL
      • campsite_id — VARCHAR(255) — Foreign key → campsite.id — NOT NULL
      • file_name — VARCHAR(255)
      • save_file_name — VARCHAR(255)
      • iamge_path — VARCHAR(255)
      • image_order — VARCHAR(255)

      campsite_option

      • id — VARCHAR(255) — Foreign key → campsite.id — NOT NULL
      • campsite_option — VARCHAR(255)

      host

      • member_id — long — Foreign key → member.id — NOT NULL
      • bank_name — VARCHAR(255)
      • account — VARCHAR(255)
      • account_holder — VARCHAR(255)

      location

      • id — long — Primary key — NOT NULL
      • location_name — VARCHAR(255)

      member

      • id — long — Primary key — NOT NULL
      • user_id — VARCHAR(255)
      • password — varchar(50)
      • user_name — VARCHAR(255)
      • phone — VARCHAR(255)
      • mail — VARCHAR(255)
      • member_type — VARCHAR(255)
      • created_at — VARCHAR(255)
      • updated_at — VARCHAR(255)

      order

      • id — long — Primary key — NOT NULL
      • member_id — long — Foreign key → member.id — NOT NULL
      • campground_id — long — Foreign key → campground.id — NOT NULL
      • price — VARCHAR(255)
      • check_in_date — VARCHAR(255)
      • check_out_date — VARCHAR(255)
      • order_status — VARCHAR(255)

      payment_method

        review

        • order_id — long — Foreign key → order.id — NOT NULL
        • campground_id — long — Foreign key → campground.id — NOT NULL
        • member_id — long — Foreign key → member.id — NOT NULL
        • message — VARCHAR(255)
        • rating — VARCHAR(255)
        • created_at — VARCHAR(255)