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)