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