캠핑어때
테이블 (8)
리뷰 (review)
- review_id — bigint — NOT NULL
- content — varchar(500)
- image_file — varchar(255)
- like_cnt — int
- rate_cnt — int
- regDate — datetime
- last_modified — datetime
- created_by — varchar(10)
- last_modified_by — varchar(10)
- camp_id — varchar(100) — NOT NULL
- member_id — bigint — NOT NULL
리뷰_좋아요 (review_like)
- review_like_id — NOTNULL — NOT NULL
- created_date — datetime
- last_modified — datetime
- review_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
알림 (notification)
- notification_id — NOTNULL — NOT NULL
- is_checked — NOTNULL
- last_modified — NULL
- created_date — NULL
- review_id — NOTNULL — NOT NULL
- member_id — NOTNULL — NOT NULL
양도 게시판 (a_board)
- a_no — int — NOT NULL
- no — int
- title — varchar(20)
- content — varchar(500)
- regDate — datetime
- last_modified — datetime
캠핑장 정보 (camp)
- camp_id — varchar(100) — NOT NULL
- addr1 — varchar(100)
- animal_cmg_cl — varchar(100)
- auto_site_co — int
- carav_inner_fclty — varchar(100)
- carav_site_co — int
- do_nm — varchar(10)
- eqpmn_lend_cl — varchar(20)
- extshr_co — int
- faclt_nm — varchar(20)
- feature_nm — varchar(255)
- fireSensor_co — int
- Field12 — varchar(100)
- glamp_inner_fclty — varchar(100)
- glamp_site_co — int
- homepage — varchar(100)
- induty — varchar(10)
- indvdl_carav_site_co — int
- intro — int
- lct_cl — int
- like_cnt — int
- line_intro — varchar(20)
- mapx — bigint
- mapy — bigint
- oper_de_cl — varchar(100)
- oper_pd_cl — varchar(100)
- posbl_fclty_cl — varchar(100)
- resve_cl — int
- resve_url — varchar(100)
- sbrs_cl — varchar(100)
- sbrs_etc — varchar(100)
- sigungu_nm — varchar(100)
- sited_stnc — int
- swrm_co — int
- tel — varchar(15)
- thema_envrn_cl — varchar(20)
- toilet_co — int
- tour_era_cl — varchar(20)
- reler_acmpny_at — int
- carav_acmpny_at — int
- wtrpl_co — int
캠핑장 좋아요 (camp_like)
- camp_like_id — bigint — NOT NULL
- regDate — datetime — NOT NULL
- last_modified — datetime
- camp_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
회원 (member)
- no — bigint — NOT NULL
- id — varchar(50)
- pw — varchar(20)
- name — varchar(10)
- phone — varchar(15)
- birth — int
- regdate — timestamp
- f_count — int
- lock — int