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