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')