DHT

Daily Home Training

Tables (21)

Untitled (RECOMMEND)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 게시글 / 2: 댓글
  • Field (REF) — NUMBER — NOT NULL — 참조중인 게시글/댓글 번호
  • Field (GOOD_BAD) — NUMBER — NOT NULL — 1: 좋아요 / 2: 싫어요

Untitled (ACCOUNT)

  • Key (ACCOUNT) — NUMBER — Primary key — NOT NULL — 계좌 번호
  • Field (BANK) — NOT NULL — 은행명
  • Key (ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (ORDER_PRODUCT)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (AMOUNT) — NUMBER — NOT NULL — 구매 수량
  • Field2 (POINT) — NUMBER — 사용한 포인트
  • Key (CODE) — Foreign key → Untitled.Key — NOT NULL — A: 기구 / B: 보조제 / C: 식품
  • Key (ORDER_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (RETURN)

  • Key (NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (REASON) — VARCHAR2(4000) — NOT NULL — 반품 사유
  • Field (DATE) — DATE — NOT NULL
  • Field (ACCEPT) — NUMBER — NOT NULL — 승인 여부
  • Field (STATUS) — NUMBER — NOT NULL — 반품 여부

Untitled (ORDERS)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 일반 / 2: 정기
  • Field (STATUS) — NUMBER — NOT NULL — 1: 주문접수 / 2: 배송중 / 3: 배송완료
  • Field (DATE) — DATE — NOT NULL
  • Field (MUID) — NOT NULL — MERCHANT_UID (아임포트 전달 데이터)
  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (TO_NAME) — NOT NULL — 받을 사람 이름
  • Field (TO_TEL) — NOT NULL — 받을 사람 연락처
  • Field2 (TO_ADDR) — NOT NULL — 배송지 주소
  • Field2 (TO_POST) — NOT NULL — 배송지 우편 번호

Untitled (BASKET)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (CODE) — Foreign key → Untitled.Key — NOT NULL — A: 기구 / B: 보조제 / C: 식품
  • Field (AMOUNT) — NUMBER — NOT NULL — 희망 수량
  • Field (DATE) — DATE — NOT NULL

Untitled (GRADE)

  • Key (GRADE) — NUMBER — Primary key — NOT NULL — 등급
  • Field (VAR) — NUMBER(2,1) — NOT NULL — 변수

Untitled (GOAL)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (DAYS) — NUMBER — NOT NULL — 목표 요일 number나열
  • Field (EXERCISES) — NUMBER — NOT NULL — 목표 운동 number 나열
  • Key (GRADE) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 등급

Untitled (COMMENTS)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 게시글 / 2: 댓글
  • Field (REF) — NUMBER — NOT NULL — 참조한 게시글/댓글 번호
  • Field (CONTENT) — VARCHAR2(4000) — NOT NULL — 댓글 내용
  • Field (DATE) — DATE — NOT NULL
  • Key (ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (BOARD)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 자유 / 2 : 광고 / 3: 공지
  • Field (TITLE) — NOT NULL — 제목
  • Field (CONTENT) — VARCHAR2(4000) — NOT NULL — 내용
  • Field (COUNT) — NUMBER — NOT NULL — 조회수
  • Field (DATE) — DATE — NOT NULL
  • Key (ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (REPORT)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL — 신고한 사용자
  • Field (TYPE) — NUMBER — NOT NULL — 1: 게시글 / 2: 댓글
  • Field (REF) — NUMBER — NOT NULL — 참조중인 게시글 / 댓글 번호
  • Field (REASON) — NUMBER — NOT NULL — 1: 욕설 / 2: 거짓 / 3: 중복 / 4: 기타
  • Field (DETAIL) — VARCHAR2(4000) — NOT NULL — 상세 내용
  • Field (MANAGE) — NUMBER — NOT NULL — 조치 여부
  • Field (DAYS) — NUMBER — 1: 1일 / 2: 3일 / 3: 7일 / 4: 30일
  • Field (NOTE) — VARCHAR2(4000) — 비고
  • Field (DATE) — DATE — NOT NULL
  • Key (TARGET) — Foreign key → Untitled.Key — NOT NULL — 신고 대상 사용자

Untitled (USERS)

  • Key (ID) — Primary key — NOT NULL
  • Field (PW)
  • Field (NAME)
  • Field (NICK)
  • Field (BIRTH) — DATE
  • Field (GENDER)
  • Field (MAIL)
  • Field (TEL)
  • Field (ADDR) — 주소
  • Field (POST) — 우편 번호
  • Field (DATE) — DATE — NOT NULL
  • Field (REPORT) — DATE — 계정 정지 기한
  • Field (LEAVE) — NUMBER — NOT NULL — 탈퇴 여부

Untitled (EXERCISE)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 전신 / 2: 상체 / 3: 하체
  • Field (NAME) — NOT NULL
  • Field (CAL) — NUMBER — NOT NULL — 소모 칼로리
  • Field (DESC) — VARCHAR2(4000) — NOT NULL — 운동 설명
  • Field (COUNT) — NUMBER — NOT NULL — 1단계 기준 횟수/시간

Untitled (RECORD)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (DATE) — DATE — NOT NULL
  • Field (RECORD) — NUMBER — NOT NULL — 기록(횟수 OR 초)
  • Key (EX_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (FILES)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 프로필사진 / 2: 상품이미지 / 3: 게시판첨부파일
  • Field (REF) — NOT NULL — 참조중인 사용자/상품/게시글 PRIMARY KEY
  • Field (PATH) — VARCHAR2(4000) — NOT NULL — 저장 경로
  • Field (ORIGIN) — VARCHAR2(4000) — NOT NULL — 원본명
  • Field (RENAME) — VARCHAR2(4000) — NOT NULL — 변경한 파일명
  • Field (EXT) — NOT NULL — 확장자
  • Field (SIZE) — NUMBER — NOT NULL — 파일 크기
  • Field (THUMBNAIL) — NUMBER — NOT NULL — 섬네일 여부

Untitled (REVIEW)

  • Key (NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (SCORE) — NUMBER(2,1) — NOT NULL — 평점
  • Field (REVIEW) — VARCHAR2(4000) — NOT NULL — 후기
  • Field (DATE) — DATE — NOT NULL

Untitled (PRODUCT_INITIAL)

  • Key (CODE) — Foreign key → Untitled.Key — NOT NULL — A: 기구 / B: 보조제 / C: 식품
  • Field (PRODUCT_INITIAL) — NOT NULL — 해당 상품의 초성

Untitled (PRODUCT)

  • Key (CODE) — Primary key — NOT NULL — A: 기구 / B: 보조제 / C: 식품
  • Field (NAME) — NOT NULL
  • Field (COMPANY) — NOT NULL — 제조 업체
  • Field (PRICE) — NUMBER — NOT NULL
  • Field (DESC) — VARCHAR2(4000) — NOT NULL — 설명
  • Field (DATE) — DATE — NOT NULL
  • Field (STOCK) — NUMBER — NOT NULL — 재고
  • Field (SELL) — NUMBER — NOT NULL — 판매 여부

Untitled (EVENT)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (DATE) — DATE — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1: 출석 / 2: 초성

Untitled (COMPENSATION)

  • Key (ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (DATE) — DATE — NOT NULL
  • Field (TYPE) — NUMBER — NOT NULL — 1 : 포인트 / 2 : 코인
  • Field2 (EVENT) — NUMBER — 1: 출석 / 2: 초성 / 3: 룰렛 / 4: 묵찌빠 / 5: 기록 / 6: 단어
  • Field (INC) — NUMBER — NOT NULL — 증가 (INCREASE)
  • Field (DEC) — NUMBER — NOT NULL — 감소 (DECREASE)

Untitled (ADMIN)

  • Key (ID) — Primary key — NOT NULL
  • Field (PW) — NOT NULL
  • Field (NAME) — NOT NULL