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)