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