project1

테이블 (7)

게시판 (board)

  • board_seq_no — INT
  • user_seq_no — INT — NOT NULL
  • board_gubun — ENUM('gongji','diary')
  • board_title — VARCHAR(200)
  • board_content — TEXT
  • board_view — INT
  • board_create_date — DATETIME
  • board_update_date — DATETIME
  • board_delete_check — ENUM('Y','N')

다이어리 (diary)

  • user_seq_no (user_seq_no2) — NOT NULL — 외래 키 → 회원정보.user_seq_no — NOT NULL
  • diary_seq_no — INT
  • user_seq_no — INT — NOT NULL
  • trip_title — VARCHAR(200)
  • diary_title — VARCHAR(200)
  • diary_content — TEXT
  • diary_tags — JSON
  • diary_frame_file — INT
  • diary_status — ENUM('public','private','framed')
  • diary_create_date — DATETIME
  • diary_update_date — DATETIME

댓글 (comment)

  • comment_seq_no — INT
  • board_seq_no — INT — NOT NULL
  • user_seq_no — INT — NOT NULL
  • comment_content — VARCHAR(500)
  • comment_create_date — DATETIME
  • comment_update_date — DATETIME
  • comment_delete_check — ENUM('Y','N')

미션 (mission)

  • mission_seq_no — INT
  • user_seq_no — INT — NOT NULL
  • mission_name — VARCHAR(100)
  • mission_detail — TEXT
  • mission_type — ENUM('random','location','game','photo') — NOT NULL
  • mission_reward — INT
  • mission_status — ENUM('pending','done','failed','expired')
  • mission_lat — DOUBLE
  • mission_lng — DOUBLE
  • mission_create_date — DATETIME
  • mission_update_date — DATETIME

채팅 (chat)

  • chat_seq_no — INT
  • user_seq_no — INT — NOT NULL
  • chat_type — ENUM('user-ai','mission','friend') — NOT NULL
  • session_id — VARCHAR(100)
  • chat_message — TEXT — NOT NULL
  • chat_metadata — JSON
  • chat_create_date — DATETIME

파일 (file)

  • file_seq_no — INT
  • file_name — TEXT
  • file_extension — VARCHAR(10)
  • file_target_type — ENUM('board','mission','diary','profile','frame','log') — NOT NULL
  • file_target_seq — INT — NOT NULL
  • file_create_date — DATETIME

회원정보 (user)

  • user_seq_no — NOT NULL — 기본 키 — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • user_pw — VARCHAR(255) — NOT NULL
  • user_nickname — VARCHAR(50) — NOT NULL
  • user_email — VARCHAR(100) — NOT NULL
  • user_birth — DATE
  • user_theme_hate — VARCHAR(200)
  • user_food_hate — VARCHAR(200)
  • user_region_hate — VARCHAR(200)
  • user_addr1 — VARCHAR(100)
  • user_addr2 — VARCHAR(100)
  • user_create_date — DATETIME
  • user_update_date — DATETIME
  • user_delete_check — ENUM('Y','N')