erd

Tables (7)

hobby

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • hobby_category — enum('CULTURAL_LIFE','ETC','EXERCISE','FOOD','GAME','MUSIC','TRAVEL')

hobby_board

  • id — bigint — Primary key — NOT NULL
  • thumbs_up — int — NOT NULL
  • user_id — bigint
  • description — varchar(255)
  • title — varchar(255)
  • video_link — varchar(255)
  • hobby_category — enum('CULTURAL_LIFE','ETC','EXERCISE','FOOD','GAME','MUSIC','TRAVEL')

profile

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint
  • user_id — bigint
  • major — varchar(255)
  • nice_experience — varchar(255)
  • plan — varchar(255)
  • image — mediumblob
  • mbti — enum('ENFJ','ENFP','ENTJ','ENTP','ESFJ','ESFP','ESTJ','ESTP','INFJ','INFP','INTJ','INTP','ISFJ','ISFP','ISTJ','ISTP')

profile_hobby

  • hobby_id — bigint — NOT NULL
  • profile_id — bigint — NOT NULL

profile_request

  • id — bigint — Primary key — NOT NULL
  • profile_id — bigint
  • user_id — bigint
  • request_status — enum('APPROVED','PENDING','REJECTED')
  • request_type — enum('REGISTER','UPDATE')

region

  • id — bigint — Primary key — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL
  • name — varchar(255)

user

  • id — bigint — Primary key — NOT NULL
  • gender — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • username — varchar(255)
  • role — enum('ADMIN','USER')