323414

Tables (16)

BOARD

  • BOARD_NO — LONG
  • BOARD_CATEGORY_NO — LONG — NOT NULL
  • USER_ID — VARCHAR2(30) — NOT NULL
  • BOARD_TITLE — VARCHAR2(50) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(255) — NOT NULL
  • COUNT — LONG — NOT NULL
  • HEART — LONG — NOT NULL
  • CREATED_DATE — DATE — NOT NULL
  • UPDATED_DATE — DATE — NOT NULL
  • STATUS — CHAR(1) — NOT NULL

BOARD_CATEGORY

  • BOARD_CATEGORY_NO — LONG
  • BOARD_CATEGORY_NAME — VARCHAR2(20) — NOT NULL

BOARD_FILE

  • BOARD_NO — LONG — NOT NULL
  • ORIGIN_NAME — VARCHAR2(255) — NOT NULL
  • CHANGE_NAME — VARCHAR2(255) — NOT NULL

CAREER

  • CAREER_NO — LONG
  • TRAINER_NO — LONG — NOT NULL
  • CONTENT — VARCHAR2(100) — NOT NULL

COMMENT

  • undefined_NO — LONG — NOT NULL
  • USER_ID — VARCHAR2(30) — NOT NULL
  • undefined_CONTENT — VARCHAR2(255) — NOT NULL

EXERCISE

  • EXERCISE_NO — LONG
  • EXERCISE_NAME — VARCHAR2(30) — NOT NULL
  • EXERCISE_TARGET — VARCHAR2(20) — NOT NULL
  • EXERCISE_ITEM — VARCHAR2(30)
  • EXERCISE_WEIGHT — LONG
  • EXERCISE_COUNT — LONG — NOT NULL
  • EXERCISE_SET — LONG — NOT NULL
  • EXERCISE_ORIGIN — VARCHAR2(100) — NOT NULL
  • EXERCISE_CHANGE — VARCHAR2(100) — NOT NULL

HEALTH

  • USER_ID — VARCHAR2(30) — NOT NULL
  • HEIGHT — DOUBLE
  • WEIGHT — DOUBLE
  • BMI — DOUBLE — 계산필요
  • FIELD — VARCHAR(255)

MEMBER

  • USER_ID — VARCHAR2(30)
  • USER_PWD — VARCHAR2(50) — NOT NULL
  • TRAINER_NO — LONG
  • USER_EMAIL — VARCHAR2(100) — NOT NULL
  • USER_NAME — VARCHAR2(20) — NOT NULL
  • USER_BIRTH — DATE — NOT NULL
  • ADDRESS — VARCHAR2(100)
  • GENDER — CHAR(1) — M, W
  • GOAL — NUMBER
  • PROFILE_IMAGE — VARCHAR2(255)
  • STATUS — CHAR(1) — NOT NULL — Y, N
  • GRADE — CHAR(1) — NOT NULL — A:관리자, U:회원, C:트레이너
  • ENROLL_DATE — DATE — NOT NULL
  • UPDATED_DATE — DATE — NOT NULL

NOTICE

  • NOTICE_NO — LONG
  • USER_ID — VARCHAR2(30) — NOT NULL
  • NOTICE_TITLE — VARCHAR2(50) — NOT NULL
  • NOTICE_CONTENT — VARCHAR2(255) — NOT NULL
  • CREATED_DATE — DATE — NOT NULL
  • UPDATED_DATE — DATE — NOT NULL
  • STATUS — CHAR(1) — NOT NULL

PAYMENT2

  • PAYMENT_ID — LONG
  • REQUEST_ID — VARCHAR2(30) — NOT NULL
  • PAYMENT_AMOUNT — LONG — NOT NULL
  • TRANSACTION_ID — VARCHAR2(100) — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(10) — NOT NULL — TOSS,KAKAO,CARD,BANK,NAVER
  • PAYMENT_STATUS — VARCHAR2(10) — NOT NULL — PENDING, CANCELED, SUCCESS, FAILED
  • PAYMENT_AT — DATE — NOT NULL
  • PAYMENT_CANCEL — DATE
  • PRODUCT_NAME — VARCHAR2(255) — NOT NULL

REQUEST

  • REQUEST_ID — VARCHAR2(30)
  • USER_ID — VARCHAR2(30) — NOT NULL
  • TRAINER_NO — LONG — NOT NULL
  • TOTAL_COUNT — LONG — NOT NULL
  • BOOK_DATE — DATE — NOT NULL
  • STATUS — CHAR(1)

RESERVATION

  • RESERVATION_NO — LONG
  • REQUEST_ID — VARCHAR2(30) — NOT NULL
  • TRAINER_NO — LONG — NOT NULL
  • SELECT_DATE — DATE — NOT NULL
  • COUNT — LONG — NOT NULL
  • PRICE — LONG — NOT NULL
  • STATUS — CHAR(1) — NOT NULL — W:대기, A:승인, R:거절, F:완료, C:취소
  • CREATE_DATE — DATE — NOT NULL

REVIEW

  • REVIEW_NO — LONG
  • USER_ID — VARCHAR2(30) — NOT NULL
  • TRAINER_NO — LONG — NOT NULL
  • REVIEW_CONTENT — VARCHAR2(255) — NOT NULL
  • RATING — LONG — NOT NULL
  • HEART — LONG — NOT NULL
  • CREATED_DATE — DATE — NOT NULL
  • STATUS — CHAR(1) — NOT NULL

TRAINER

  • TRAINER_NO — LONG
  • TRAINER_CATEGORY_NO — LONG — NOT NULL
  • WISH_AREA — VARCHAR2(20) — NOT NULL
  • KAKAO_ID — VARCHAR2(30)
  • INSTA_ID — VARCHAR2(30)
  • ONCE_PRICE — LONG — NOT NULL
  • DISCOUNT_3 — LONG — NOT NULL
  • DISCOUNT_5 — LONG — NOT NULL
  • DISCOUNT_10 — LONG — NOT NULL
  • INTRODUCE — VARCHAR2(200)

TRAINER_CATEGORY

  • TRAINER_CATEGORY_NO — LONG
  • TRAINER_CATEGORY_NAME — VARCHAR2(20) — NOT NULL

TRAINER_FILE

  • TRAINER_NO — LONG — NOT NULL
  • ORIGIN_NAME — VARCHAR2(255) — NOT NULL
  • CHANGE_NAME — VARCHAR2(255) — NOT NULL