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)