joymunch

Tables (23)

Box (박스 테이블)

  • id (primary) — Primary key — NOT NULL
  • categoryid (foreginkey) — Foreign key → Category.id — NOT NULL
  • images (이미지)
  • title (박스명) — VARCHAR
  • info (박스 정보) — VARCHAR
  • marketprice (원가) — INTEGER
  • price (판매가) — INTEGER
  • savecount (적립금 적립률) — FLOAT
  • delivery (배송방법) — VARCHAR
  • memebership (멤버혜택) — VARCHAR
  • tast (Field4)
  • type (배송타입 0 무료배송) — BOOLEAN
  • updatedAt (Field) — DATE
  • creadtedAt (Field2) — DATE
  • isvalidate (Field3)

CartBox (장바구니필드)

  • id (primary) — Primary key — NOT NULL
  • userid (아이디) — Foreign key → User.id — NOT NULL
  • boxid (박스필드) — Foreign key → Box.id — NOT NULL
  • uusid (Key) — Foreign key → uus.id — NOT NULL
  • count (갯수필드)
  • type (uuid/ foregion)
  • size (사이즈)
  • days (구독주차)
  • deliverytype (배송방식)
  • option (구성)

Category (카테고리)

  • id (primary) — Primary key — NOT NULL
  • title (카테고리명) — VARCHAR
  • ison (활성화여부)
  • updatedAt (Field) — DATE
  • createdAt (Field2) — DATE

Cnfgr (CopyOf맛)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • isavlidate (Field2)

Coupon (쿠폰)

  • id (쿠폰아이디) — Primary key — NOT NULL
  • userid (발급유저아이디) — Foreign key → User.id — NOT NULL
  • code (쿠폰코드) — VARCHAR
  • sale (할인금액) — VARCHAR
  • price (사용기준금액)
  • reorder (중복 사용가능여부)
  • info (쿠폰설명)
  • updatedAt (수정일) — DATE
  • createdAt (생성일) — DATE
  • isdect (사용여부)
  • prgroup (쿠폰결제 제외그룹)
  • group (쿠폰결제 제외상품)
  • start (시작일)
  • end (종료일)

OrderList (주문내역)

  • id (키값) — Primary key — NOT NULL
  • userid — Foreign key → User.id — NOT NULL
  • uusid (Key) — Foreign key → uus.id — NOT NULL
  • type (Field2)
  • saleprice (Field)
  • saletype (Field3)
  • deliverytype (Field4)
  • count (Field5)
  • size (Field6)
  • option (Field7)
  • iamcode (Field8)
  • isvalidate (Field9)
  • isType (Field10)
  • code (Field11)

User (회원 테이블)

  • id (primary) — Primary key — NOT NULL
  • authtype (local naver kakao) — VARCHAR
  • email (이메일) — VARCHAR
  • password (비밀번호) — VARCHAR
  • point (포인트) — INTEGER
  • name (유저이름)
  • tel (연락처) — VARCHAR
  • birthday (생년월일) — DATE
  • zip (배송지)
  • zipinfo (상세주소)
  • zipcode (우편번호)
  • showinfo (이벤트 수신 동의여부) — BOOLEAN
  • gm (관리자) — BOOLEAN
  • access (관리자 승인여부)
  • isvalidate (체크용) — BOOLEAN
  • subscript (구독여부)
  • days (구독기간)
  • createdAt (created At) — DATE
  • updatedAt (updated At) — DATE

board (보드)

  • id (보드아이디) — Primary key — NOT NULL
  • type (보드형식 0 공지사항 1 자주묻는질문 2 제안하기 3 이벤트)
  • title (제목)
  • contetns (내용)
  • createdAt (생성일)
  • updatedAt (Field)
  • isvalidate (체크용)
  • images (이미지)

boxinfo (박스상세)

  • id (Key) — Primary key — NOT NULL
  • boxid (primary) — Foreign key → Box.id — NOT NULL
  • contetns (Field)

boxqa (Q&A)

  • id (아이디) — Primary key — NOT NULL
  • userid (foregionkey) — Foreign key → User.id — NOT NULL
  • boxid (foregionkey2) — Foreign key → Box.id — NOT NULL
  • contetns (내용입니다)
  • ison (응답여부)

cardInfo (정기구독카드정보)

  • id (Key) — Primary key — NOT NULL
  • userid (foregion) — Foreign key → User.id — NOT NULL
  • number (Field)

comment (댓글필드)

  • id (Key) — Primary key — NOT NULL
  • boardid (보드아이디) — Foreign key → board.id — NOT NULL
  • userid (foregionkey) — Foreign key → User.id — NOT NULL
  • title (Field)
  • contents (Field2)

days (배송주차 필드)

  • id (Key) — Primary key — NOT NULL
  • title (배송주에 관한 내용)

kakao_message (카카오 메세지리스트)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • contents (Field2)
  • images (Field3)

kindTaste (맛)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • isvalidate (Field2)

lineup (라인업리스트)

  • id (Key) — Primary key — NOT NULL
  • product_lineupid (foreginkey) — Foreign key → product_lineup.id — NOT NULL
  • images (라인업 이미지)
  • title (제목)
  • name (제품명)
  • brand (브랜드)
  • office (제조사)
  • txtr (식감)
  • nutrition (영양이점)
  • vgtbl (식물성 여부)
  • info (설명)
  • isvalidate (Field)

liview (상품리뷰)

  • id (Key) — Primary key — NOT NULL
  • boxid (foregionkey) — Foreign key → Box.id — NOT NULL
  • userid (외래참조2) — Foreign key → User.id — NOT NULL
  • contetns (리뷰내용)
  • images (이미지)
  • stars (별점)

product_lineup (라인업 카테고리)

  • id (Key) — Primary key — NOT NULL
  • boxid (foreginkey) — Foreign key → Box.id — NOT NULL
  • title (라인업명)

size (사이즈)

  • id (Key) — Primary key — NOT NULL
  • title (사이즈에 관한 내용)
  • price (사이즈별 가격)

subscript (구독기간 관련)

  • id (Key) — Primary key — NOT NULL
  • title (구독기간내용)

user_couponuse (쿠폰 발급/사용 내역)

  • id (primarykey) — Primary key — NOT NULL
  • userid (foreign) — Foreign key → User.id — NOT NULL
  • couponid (쿠폰아이디) — Foreign key → Coupon.id — NOT NULL
  • info (쿠폰 발급/사용/내용) — VARCHAR
  • sale (쿠폰 할인내용) — VARCHAR
  • updatedAt (쿠폰변경일) — DATE
  • createdAt (쿠폰생성일) — DATE

user_pointuse (유저 포인트 지급/사용)

  • Key — Primary key — NOT NULL
  • userid (foreign) — Foreign key → User.id — NOT NULL
  • point (사용/발급 포인트) — VARCHAR
  • info (내용) — VARCHAR
  • updatedAt (수정날짜) — DATE
  • creadAt (발급날짜) — DATE

uus (비회원 테이블)

  • id (Key) — Primary key — NOT NULL
  • uuid (비회원주문 아이디)
  • tel (휴대폰번호)
  • zip (주소)
  • zipinfo (상세주소)
  • zipcode (우편번호)