Pecommend
Tables (18)
comment
- comment_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
- content — VARCHAR(1000) — NOT NULL
- depth — INT
- parent_id — BIGINT
- is_deleted — TINYINT
- created_date — VARCHAR(45) — NOT NULL
- modified_date — VARCHAR(45) — NOT NULL
- INDEX — `comment_fk_users_idx`
- INDEX — `comment_fk_community_idx`
comment_dislike
- comment_dislike_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `comment_dislike_fk_users_idx`
- INDEX — `comment_dislike_fk_comment_idx`
comment_like
- comment_like_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `comment_like_fk_comment_idx`
- INDEX — `comment_like_fk_users_idx`
community
- community_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — INT — NOT NULL
- title — VARCHAR(45) — NOT NULL
- content — VARCHAR(20000) — NOT NULL
- created_date — VARCHAR(45) — NOT NULL
- modified_date — VARCHAR(45) — NOT NULL
- INDEX — `community_fk_users_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 — `community_like_fk_community_idx`
- INDEX — `coummunity_like_fk_users_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`
- INDEX — `note_fk_perfume`
perfume
- perfume_id — BIGINT — Primary key — NOT NULL
- perfume_name_ko — VARCHAR(100) — NOT NULL
- perfume_name_en — VARCHAR(100) — NOT NULL
perfume_dislike
- perfume_dislike_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
- INDEX — `perfume_dislike_fk_perfume_idx`
- INDEX — `perfume_dislike_fk_users_idx`
perfume_like
- perfume_like_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
- INDEX — `perfume_like_fk_perfume_idx`
- INDEX — `perfume_like_fk_users_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 — `perfume_tag_fk_tag_idx`
- INDEX — `perfume_tag_fk_perfume_idx`
regist
- regist_id — BIGINT — Primary key — NOT NULL
- user_name — VARCHAR(45) — NOT NULL
- company — VARCHAR(100) — NOT NULL
- describe — VARCHAR(200) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- img — VARCHAR(200)
- status — INT — NOT NULL
review
- review_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
- content — VARCHAR(1000) — NOT NULL
- score — INT — NOT NULL
- created_date — VARCHAR(45) — NOT NULL
- modified_date — VARCHAR(45) — NOT NULL
- INDEX — `review_fk_perfume_idx`
- INDEX — `review_fk_users_idx`
review_dislike
- review_dislike_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `review_fk_like_idx`
- INDEX — `user_fk_like_idx`
review_like
- review_like_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- INDEX — `review_like_fk_review_idx`
- INDEX — `review_like_fk_users_idx`
review_tag
- review_tag_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- INDEX — `review_tag_fk_review_idx`
- INDEX — `review_tag_fk_tag_idx`
tag
- tag_id — BIGINT — Primary key — NOT NULL
- tag_name — VARCHAR(45) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(45) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- birthday — VARCHAR(20)
- age — INT
- gender — VARCHAR(10)
- mbti — VARCHAR(4)
- introduction — VARCHAR(100)
- role — VARCHAR(15)
- token — VARCHAR(200)