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)