peco
Tables (19)
category
- category_id — BIGINT — Primary key — NOT NULL
- category_name — VARCHAR(45)
comment_like
- comment_like_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → community_comment.comment_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- like — TINYINT — NOT NULL
- INDEX — `comment_fk_like_idx`
- INDEX — `user_fk_like_idx`
community
- community_id — BIGINT — Primary key — NOT NULL
- category — BIGINT — Foreign key → category.category_id — NOT NULL
- writer — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(45) — NOT NULL
- content — VARCHAR(20000) — NOT NULL
- regdate — DATETIME — NOT NULL
- INDEX — `category_fk_board_idx`
- INDEX — `user_fk_board_idx`
community_comment
- comment_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → community.community_id — NOT NULL
- writer — BIGINT — Foreign key → users.user_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- like — INT — NOT NULL
- dislike — INT — NOT NULL
- regdate — DATETIME — NOT NULL
- INDEX — `board_comment_fk_board_idx`
- INDEX — `board_comment_fk_user_idx`
community_like
- community_like_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → community.community_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `board_fk_like_idx`
- INDEX — `user_fk_like_idx`
img
- img_id — BIGINT — Primary key — NOT NULL
- upload_file_name — VARCHAR(200) — NOT NULL
- store_file_name — VARCHAR(200) — NOT NULL
- filepath — VARCHAR(200) — NOT NULL
- community_id — BIGINT — Foreign key → community.community_id — NOT NULL
- regist_id — BIGINT — Foreign key → perfume_regist.regist_id — NOT NULL
- INDEX — `community_fk_img_idx`
- INDEX — `regist_fk_img_idx`
material
- material_id — BIGINT — Primary key — NOT NULL
- material_name — VARCHAR(45) — NOT NULL
- info — VARCHAR(200)
note
- note_id — BIGINT — Primary key — NOT NULL
- perfume_id — BIGINT — Foreign key → perfume.perfume_id — NOT NULL
- material_id — BIGINT — Foreign key → material.material_id — NOT NULL
- note — VARCHAR(45) — NOT NULL
- INDEX — `m_id_idx`
perfume
- perfume_id — BIGINT — Primary key — NOT NULL
- perfume_name — VARCHAR(100) — NOT NULL
- like — INT — NOT NULL
- dislike — INT — NOT NULL
- density — VARCHAR(45)
perfume_regist
- regist_id — BIGINT — Primary key — NOT NULL
- writer — BIGINT — Foreign key → users.user_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- regdate — DATETIME — NOT NULL
- like — INT — NOT NULL
- INDEX — `user_fk_rec_idx`
perfume_review
- perfume_review_id — BIGINT — Primary key — NOT NULL
- perfume_id — BIGINT — Foreign key → perfume.perfume_id — NOT NULL
- writer — BIGINT — Foreign key → users.user_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- like — INT — NOT NULL
- score — INT — NOT NULL
- regdate — DATETIME — NOT NULL
- tag1 — INT — Foreign key → tag.tag_id
- tag2 — INT — Foreign key → tag.tag_id
- tag3 — INT — Foreign key → tag.tag_id
- INDEX — `perfume_fk_comment_idx`
- INDEX — `user_fk_comment_idx`
- INDEX — `tag_fk_review_idx`
- INDEX — `tag2_fk_review_idx`
- INDEX — `tag3_fk_review_idx`
perfume_tag
- perfume_tag_id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- perfume_id — BIGINT — Foreign key → perfume.perfume_id — NOT NULL
- count — INT — NOT NULL
- INDEX — `tag_fk_pt_idx`
- INDEX — `perfume_fk_pt_idx`
preference
- preference_id — BIGINT — Primary key — NOT NULL
- perfume_id — BIGINT — Foreign key → perfume.perfume_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- preferecne — TINYINT — NOT NULL
- INDEX — `perfume_fk_preference_idx`
- INDEX — `user_fk_preference_idx`
profile_show
- profile_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- age_show — TINYINT — NOT NULL
- gender_show — TINYINT — NOT NULL
- mbti_show — TINYINT — NOT NULL
- experience_show — TINYINT — NOT NULL
- INDEX — `user_fk_profile_idx`
regist_like
- regist_like_id — BIGINT — Primary key — NOT NULL
- regist_id — BIGINT — Foreign key → perfume_regist.regist_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `recommend_fk_like_idx`
- INDEX — `user_fk_like_idx`
review_like
- review_like_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → perfume_review.perfume_review_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `review_fk_like_idx`
- INDEX — `user_fk_like_idx`
tag
- tag_id — BIGINT — Primary key — NOT NULL
- tag_name — VARCHAR(45) — NOT NULL
user_tag
- user_tag_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- count — INT — NOT NULL
- INDEX — `user_fk_tag_idx`
- INDEX — `tag_fk_tag_idx`
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(45) — NOT NULL
- password — VARCHAR(45) — NOT NULL
- birthday — VARCHAR(20)
- gender — VARCHAR(1)
- mbti — VARCHAR(4)
- introduction — VARCHAR(100)
- role — VARCHAR(15)
- token — VARCHAR(200)