dbmodel

Tables (24)

achievement

  • achievement_id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • photo — VARCHAR(255) — NOT NULL
  • acquisition_condition — TEXT — NOT NULL
  • location — TEXT — NOT NULL

alert

  • alert_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • alert_content — TEXT — NOT NULL
  • alert_date — DATETIME — NOT NULL
  • alert_read — TINYINT — NOT NULL

board

  • board_id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • post_date — DATETIME — NOT NULL
  • view_count — INTEGER — NOT NULL
  • is_public — TINYINT — NOT NULL
  • is_deleted — TINYINT — NOT NULL

board_photo

  • photo_id — INTEGER — Primary key — NOT NULL
  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • origin_filename — VARCHAR(255) — NOT NULL

board_tag

  • tag_id — INTEGER — Primary key — NOT NULL
  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • tag_name — VARCHAR(255)

chat

  • chat_id — INTEGER — Primary key — NOT NULL
  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • chat_content — TEXT — NOT NULL
  • chat_date — DATETIME — NOT NULL

collection

  • collection_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • subcategory_id — INTEGER — Foreign key → subcategory.subcategory_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • en_name — VARCHAR(50)
  • status_id — INTEGER — Foreign key → collection_status.status_id
  • purchase_date — DATE
  • purchase_place — VARCHAR(255)
  • price — INTEGER
  • storage_location — VARCHAR(255)
  • post_date — DATETIME — NOT NULL

collection_board

  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • collection_id — INTEGER — Foreign key → collection.collection_id — NOT NULL

collection_photo

  • photo_id — INTEGER — Primary key — NOT NULL
  • collection_id — INTEGER — Foreign key → collection.collection_id — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • origin_filename — VARCHAR(255) — NOT NULL

collection_status

  • status_id — INTEGER — Primary key — NOT NULL
  • status_name — VARCHAR(255) — NOT NULL

comment

  • comment_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • content — TEXT — NOT NULL
  • date — DATETIME — NOT NULL
  • original_comment_id — INTEGER
  • is_public — TINYINT — NOT NULL

forbidden_word

  • word — VARCHAR(255) — Primary key — NOT NULL

google

  • google_id — INTEGER — Primary key — NOT NULL
  • google_name — VARCHAR(50) — NOT NULL

kakao

  • kakao_id — INTEGER — Primary key — NOT NULL
  • kakao_name — VARCHAR(50) — NOT NULL

likes

  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL

maincategory

  • maincategory_id — INTEGER — Primary key — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

naver

  • naver_id — INTEGER — Primary key — NOT NULL
  • naver_name — VARCHAR(50) — NOT NULL

report

  • report_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • report_content — TEXT — NOT NULL
  • report_date — DATETIME — NOT NULL
  • report_result_id — INTEGER — Foreign key → report_result_category.report_result_id
  • result_content — TEXT
  • report_category_id — INTEGER — Foreign key → report_category.report_category_id — NOT NULL

report_category

  • report_category_id — INTEGER — Primary key — NOT NULL
  • category_name — VARCHAR(255) — NOT NULL

report_result_category

  • report_result_id — INTEGER — Primary key — NOT NULL
  • result_name — VARCHAR(255) — NOT NULL

subcategory

  • subcategory_id — INTEGER — Primary key — NOT NULL
  • maincategory_id — INTEGER — Foreign key → maincategory.maincategory_id — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

trade_board

  • board_id — INTEGER — Foreign key → board.board_id — NOT NULL
  • collection_id — INTEGER — Foreign key → collection.collection_id
  • price — INTEGER — NOT NULL
  • status — TINYINT — NOT NULL

user

  • user_id — INTEGER — Primary key — NOT NULL
  • photo — VARCHAR(255)
  • email — VARCHAR(40) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATE
  • admin — TINYINT — NOT NULL
  • sns_id — INTEGER — Foreign key → kakao.kakao_id

user_achievement

  • user_id — INTEGER — Foreign key → user.user_id — NOT NULL
  • achievement_id — VARCHAR(50) — Foreign key → achievement.achievement_id — NOT NULL
  • get_date — DATETIME — NOT NULL