test
Tables (13)
area_based_contents
- contentid — int — Primary key — NOT NULL
- addr1 — varchar(255)
- addr2 — varchar(255)
- areacode — int — Foreign key → area_codes.area_code
- booktour — int
- cat1 — varchar(3) — Foreign key → category_codes.category_code
- cat2 — varchar(5) — Foreign key → category_codes.category_code
- cat3 — varchar(9) — Foreign key → category_codes.category_code
- contenttypeid — int — Foreign key → content_types.content_type_id — NOT NULL
- createdtime — datetime — NOT NULL
- firstimage — varchar(2048)
- firstimage2 — varchar(2048)
- cpyrht_div_cd — varchar(10)
- mapx — double
- mapy — double
- mlevel — int
- modifiedtime — datetime — NOT NULL
- sigungucode — int
- tel — varchar(255)
- title — varchar(255) — NOT NULL
- zipcode — varchar(10)
- overview — text
area_codes
- area_code — int — Primary key — NOT NULL
- area_name — varchar(20) — NOT NULL
board
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- content — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- like_count — bigint
board_image
- id — bigint — Primary key — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- image_key — varchar(255) — NOT NULL
board_like
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- created_at — datetime — NOT NULL
category_codes
- category_code — varchar(9) — Primary key — NOT NULL
- category_name — varchar(50) — NOT NULL
comment
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- board_id — bigint — Foreign key → board.id — NOT NULL
- content — text — NOT NULL
- parent_comment_id — bigint — Foreign key → comment.id
- depth — int — NOT NULL
- is_deleted — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
content_details
- content_id — int — Foreign key → area_based_contents.contentid — NOT NULL
- overview — text
- homepage — varchar(500)
content_types
- content_type_id — int — Primary key — NOT NULL
- content_type_name — varchar(50) — NOT NULL
course_detail_images
- id — int — Primary key — NOT NULL
- content_id — int — Foreign key → area_based_contents.contentid — NOT NULL
- originimgurl — varchar(500) — NOT NULL
- smallimageurl — varchar(500)
- imgname — varchar(1000)
- cpyrhtDivCd — varchar(10)
- serialnum — varchar(50)
course_details
- id — int — Primary key — NOT NULL
- content_id — int — Foreign key → area_based_contents.contentid — NOT NULL
- sub_content_id — int
- sub_name — varchar(255)
- sub_overview — text
- sub_detail_img — varchar(500)
- sub_detail_alt — varchar(255)
- serialnum — int
- subnum — int
- created_time — datetime
- mapx — double
- mapy — double
sigungu_codes
- sigungu_code — int — Primary key — NOT NULL
- area_code — int — Foreign key → area_codes.area_code — NOT NULL
- sigungu_name — varchar(50) — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- user_name — varchar(50) — NOT NULL
- user_password — varchar(255) — NOT NULL
- user_email — varchar(100) — NOT NULL
- created_at — timestamp
- profile_image — varchar(255)