test
Tables (16)
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)
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)