myProject

Tables (5)

User_info

  • user_no (유저넘버) — Number — Primary key — NOT NULL
  • user_no (Field) — Number
  • user_id (유저아이디) — Varchar2(50)
  • user_pw (유저 비밀번호) — Varchar2(255)
  • user_name (유저이름) — Varchar2(50)
  • user_nickname (유저닉네임) — Varchar2(255)
  • user_address (유저주소) — Varchar2(255)
  • user_phone (유저전화번호) — Varchar2(255)
  • user_Img (유저 프로필사진) — Varchar2(255)
  • user_intro (유저 한줄 소개) — Varchar2(255)
  • user_role (유저 권한(상점)) — Varchar2(255)
  • created_at (유저 가입일) — DATETIME
  • updated_at (유저 정보수정일) — DATETIME

chat

  • chat_Id (채팅번호) — Number — Primary key — NOT NULL
  • seller_id (판매자id) — Number — Foreign key → product.user_no — NOT NULL
  • product_id (상품번호) — Number — Foreign key → product.product_id — NOT NULL
  • buyer_id (구매자 id) — Number — Foreign key → User_info.user_no — NOT NULL
  • last_chat (마지막 대화내용) — TIMESTAMP
  • lost_chat_at (마지막 대화내용 시간) — TIMESTAMP
  • Field
  • created_at (등록일) — DATETIME

chat_messages

  • message_id (채팅 id) — Number — Primary key — NOT NULL

product

  • product_id (상품번호) — Number — Primary key — NOT NULL
  • user_no (유저넘버) — Number — Foreign key → User_info.user_no — NOT NULL
  • category (카테고리) — Varchar2(50)
  • title (제목) — Varchar2(50)
  • price (가격) — Number
  • content (설명) — Varchar2(255)
  • status (상품상태) — Varchar2(255)
  • trade_type (거래방법) — Varchar2(255)
  • view_count (조회수) — Number
  • created_at (등록일) — DATETIME
  • refreshed_at (끌어올리기) — DATETIME

product_img

  • product_img_id (이미지id) — Varchar2(255) — Primary key — NOT NULL
  • img_list (Field) — Varchar2(255)