Web_Back

Tables (13)

board (게시판)

  • id (ID) — NN — Primary key — NOT NULL
  • board_title (게시글 제목) — NN
  • board_created_date (생성날짜) — NN

chat_image (채팅이미지)

  • image_id (이미지ID) — NN — Foreign key → image.id — NOT NULL
  • chat_message_id (채팅 메시지ID) — NN — Foreign key → chat_message.id — NOT NULL

chat_message (채팅메시지)

  • id (ID) — NN — Primary key — NOT NULL
  • chat_message_content (채팅 메시지) — NN
  • chat_message_read_or_not (읽기 여부) — NN
  • chat_message_time_stamp (타임스탬프) — NN
  • chat_message_is_image (이미지여부) — NN
  • chat_room_id (채팅방 ID) — NN — Foreign key → chat_room.id — NOT NULL

chat_room (채팅방)

  • id (ID) — NN — Primary key — NOT NULL
  • chat_room_crated_date (생성일자) — NN
  • user_id (구매자ID) — NN — Foreign key → users.ID — NOT NULL
  • product_id (상품ID) — NN — Foreign key → product_post.id — NOT NULL

comment (댓글)

  • id (ID) — NN — Primary key — NOT NULL
  • comment_content (내용) — NN
  • comment_created_date (생성 날짜) — NN
  • comment_updated_date (수정 날짜) — NN
  • post_id (게시글ID) — NN — Foreign key → post.id — NOT NULL
  • user_id (유저ID) — NN — Foreign key → users.ID — NOT NULL

image (이미지)

  • id (ID) — NN — Primary key — NOT NULL
  • image_path (경로) — NN
  • image_original_name (원본 파일 이름) — NN
  • image_crated_date (생성날짜) — NN

post (게시글)

  • id (ID) — NN — Primary key — NOT NULL
  • post_title (게시글 제목) — NN
  • post_view (조회수) — NN
  • post_content (내용) — NN
  • post_created_date (생성날짜) — NN
  • post_update_date (수정날짜) — NN
  • user_id (유저ID) — NN — Foreign key → users.ID — NOT NULL
  • board_id (게시판ID) — NN — Foreign key → board.id — NOT NULL

product_category (상품 카테고리)

  • id (ID) — NN — Primary key — NOT NULL
  • product_category_list (카테고리) — NN

product_image (상품이미지)

  • image_id (이미지ID) — NN — Foreign key → image.id — NOT NULL
  • product_ID (상품ID) — NN — Foreign key → product_post.id — NOT NULL

product_post (상품 게시글)

  • id (ID) — NN — Primary key — NOT NULL
  • product_title (상품 제목) — NN
  • product_status (상품 상태) — NN
  • product_view (조회수) — NN
  • product_content (내용) — NN
  • product_create_date (생성 일자) — NN
  • product_update_date (수정 일자) — NN
  • user_id (유저ID) — NN — Foreign key → users.ID — NOT NULL
  • category_id (카테고리ID) — NN — Foreign key → product_category.id — NOT NULL
  • board_id (게시판 ID) — NN — Foreign key → board.id — NOT NULL

profile (프로필)

  • id (ID) — NN — Primary key — NOT NULL
  • user_id (유저ID) — NN — Foreign key → users.ID — NOT NULL
  • image_id (이미지ID) — NN — Foreign key → image.id — NOT NULL

profile_image (프로필 이미지)

  • image_id (이미지ID) — NN — Foreign key → image.id — NOT NULL
  • profile_id (프로필ID) — NN — Foreign key → profile.id — NOT NULL

users (유저)

  • ID — NN — Primary key — NOT NULL
  • user_member_id (개인ID) — NN
  • user_pw (비밀번호) — NN
  • user_name (이름) — NN
  • user_nickname (닉네임) — NN
  • user_phone (전화번호) — NN
  • user_email (이메일) — NN
  • user_birth (생년월일) — NN
  • user_role (역할) — NN