Nagne ERD - 2024-08-14

Tables (11)

area

  • area_code — int — Primary key — NOT NULL
  • name — varchar(100)

festival

  • festival_id — bigint — Primary key — NOT NULL
  • place_id — bigint — Foreign key → place.place_id
  • event_start_date — date
  • event_end_date — date

oauthid

  • oauth_id — bigint — Primary key
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • provider — enum('facebook','google') — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • refresh_token — varchar(255)

place

  • place_id — bigint — Primary key
  • area_code — bigint — Foreign key → area.area_code — NOT NULL
  • title — varchar(200)
  • address — varchar(200) — NOT NULL
  • content_id — varchar(255)
  • content_type_id — bigint(15)
  • overview — longtext
  • lat — double
  • lng — double
  • likes — int(8)
  • modified_time — datetime
  • api_type — enum('tour','google','none')
  • thumbnail_url — varchar(500)

place_img

  • place_img_id — bigint — Primary key
  • place_id — bigint(20) — Foreign key → place.place_id — NOT NULL
  • img_uri — varchar(2083) — NOT NULL

plans

  • plan_id — bigint — Primary key
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • area_code — int(5) — Foreign key → area.area_code — NOT NULL
  • status — enum('begin', 'end')
  • start_day — date
  • end_day — date
  • created_at — datetime
  • updated_at — datetime
  • subject — varchar
  • overview — longtext
  • thumbnail_url — varchar(500)

review_img

  • review_img_id — bigint — Primary key
  • review_id — bigint — Foreign key → reviews.review_id
  • byte_size — int(9) — NOT NULL
  • height — int(5) — NOT NULL
  • width — int(5) — NOT NULL
  • domain — varchar(100) — NOT NULL
  • domain_path — varchar(500) — NOT NULL
  • thumnail_yn — tinyint(1)

reviews

  • review_id — bigint — Primary key
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • plan_id — bigint — Foreign key → plans.plan_id
  • created_at — datetime
  • last_updated — datetime — NOT NULL
  • text — longtext — NOT NULL
  • vote_count — int(11) — NOT NULL
  • contents_id — bigint(20)

store

  • store_id — bigint — Primary key
  • place_id — bigint(20) — Foreign key → place.place_id — NOT NULL
  • opentime — varchar(1000)
  • infocenter — varchar(50)

templates

  • template_id — bigint — Primary key — NOT NULL
  • plan_id — bigint — Foreign key → plans.plan_id
  • place_id — bigint — Foreign key → place.place_id
  • type — tinyint
  • days — bigint(20)
  • orders — bigint(20)
  • move_time (movetime) — time
  • plce_summary — longtext
  • reasonning — longtext

users

  • user_id — bigint — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(255)
  • nickname — varchar(50) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • nation — int(4)
  • profile_img — varchar(255)
  • role — enum('ADMIN','USER')
  • term_agreed — tinyint