캠핑어때2
테이블 (8)
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
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
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