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