soldout1
Tables (12)
ADDRESS
- address_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- 주소명 (address_name) — VARCHAR(20) — NOT NULL
- 받는사람 (recipient) — VARCHAR(20) — NOT NULL
- 전화번호 (phone_num) — VARCHAR(11) — NOT NULL
- 주소 (address) — VARCHAR(20) — NOT NULL
- 상세주소 (detail) — VARCHAR(20) — NOT NULL
- 배송지 (basic) — TINYINT — NOT NULL — 1:기본배송지
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
BRAND_IMAGE
- brand_img_id — BIGINT — Primary key — NOT NULL
- 브랜드명 (title) — VARCHAR(100)
- 이미지 주소 (image_url) — VARCHAR(255)
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
FAVORITE
- favorite_Id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- product_id — BIGINT — Foreign key → Product.product_id — NOT NULL
- size_id — BIGINT — Foreign key → SIZE.size_id
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
Image (IMAGE)
- image_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.product_id — NOT NULL
- 이미지주소 (url) — VARCHAR(255)
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
MAGAZINE
- magazine_id — BIGINT — Primary key — NOT NULL
- 종류 (type) — VARCHAR(60) — NOT NULL — pictroial, coordi, interview,event
- 제목 (title) — VARCHAR(100) — NOT NULL
- 이미지주소 (image_url) — VARCHAR(255)
- 내용주소 (contents_url) — VARCHAR(255) — NOT NULL
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
NOTICE
- notice_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- product_id — BIGINT — Foreign key → Product.product_id — NOT NULL
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
ORDER_HISTORY
- order_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- product_id — BIGINT — Foreign key → Product.product_id — NOT NULL
- size_id — BIGINT — Foreign key → SIZE.size_id — NOT NULL
- 타입(구매/판매) (type) — VARCHAR(10) — NOT NULL — buy, sell
- 희망가격 (hope_price) — INT — NOT NULL
- 총가격 (total_price) — INT — NOT NULL
- 입찰종료기한 (term) — INT — NOT NULL
- 거래상태 (order_state) — TINYINT — NOT NULL — 거래완료:1,거래중:0
- 거래완료자 (trade_id) — TINYINT
- 거래완료 시간 (complete_time) — DATATIME
- 주소 (address) — VARCHAR(20)
- 반송지 (return_address) — VARCHAR(255)
- 은행 (bank) — VARCHAR(10)
- 계좌 (account) — INT
- 판매자명 (seller_name) — VARCHAR(20)
- 포인트 (point) — INT
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
POINT_HISTORY
- point_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
- 포인트 (point) — INT — NOT NULL
- 종류(적립,사용) (type) — VARCHAR(20) — NOT NULL
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
PURCHASE
- purchase_id — BIGINT — Primary key — NOT NULL
- 구매처명 (purchase_name) — VARCHAR(20) — NOT NULL
- 이미지주소 (image_url) — VARCHAR(50) — NOT NULL
- 홈페이지주소 (homepage_url) — VARCHAR(50) — NOT NULL
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
Product (PRODUCT)
- product_id — BIGINT — Primary key — NOT NULL
- brand_img_id — BIGINT — Foreign key → BRAND_IMAGE.brand_img_id — NOT NULL
- purchase_id — BIGINT — Foreign key → PURCHASE.purchase_id
- 상품명 (product_name) — VARCHAR(20) — NOT NULL
- 클릭수 (click_count) — INT
- 상품명 영어 (product_name_eng) — VARCHAR(20) — NOT NULL
- 브랜드 (brand) — VARCHAR(20)
- 모델넘버 (model_num) — VARCHAR(20) — NOT NULL
- 출시일 (release_day) — DATETIME
- 색상 (color) — VARCHAR(20) — NOT NULL
- 가격 (price) — INT — NOT NULL — 발매가
- 카테고리 (category) — VARCHAR(20) — NOT NULL — 스니커즈, 스트릿웨어, 럭셔리, 토이/레고, 라이프
- 타입 (type) — VARCHAR(20) — clothes,shoese
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
SIZE
- size_id — BIGINT — Primary key — NOT NULL
- 사이즈명 (size_name) — VARCHAR(20) — NOT NULL
- 타입 (type) — VARCHAR(30) — NOT NULL — clothes,shoese
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP
USER
- user_id — BIGINT — Primary key — NOT NULL
- 아이디 (id) — VARCHAR(20) — NOT NULL
- 비밀번호 (password) — VARCHAR(30) — NOT NULL
- 핸드폰 번호 (phone_num) — VARCHAR(11) — NOT NULL
- 이메일 (email) — VARCHAR(20) — NOT NULL
- 사용자명 (name) — VARCHAR(20) — NOT NULL
- 닉네임 (nickname) — VARCHAR(20) — NOT NULL
- 포인트 (point) — INT — NOT NULL
- 상태 (status) — TINYINT — NOT NULL
- 등록시간 (created_at) — TIMESTAMP — NOT NULL
- 업데이트시간 (updated_at) — TIMESTAMP