ホンギピョWOD'sGYM

Tables (25)

ACCOUNT

  • ACCOUNTSEQ — NUMBER(30) — Primary key — NOT NULL
  • money — number(30)
  • sales — number(30)
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ — NOT NULL

CHAT

  • CHATSEQ — NUMBER(30) — Primary key — NOT NULL
  • SENDSEQ — NUMBER — NOT NULL
  • RECEIVESEQ — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(2000) — NOT NULL
  • CHATDATE — DATE
  • chatroomseq — number
  • name — varchar2(50)

COMMENTS

  • REPLYSEQ — NUMBER(30) — Primary key — NOT NULL
  • DEPTH — NUMBER(30)
  • ORIGIN — NUMBER(30)
  • CONTENT — VARCHAR2(2000)
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ — NOT NULL
  • LESSONLISTSEQ — NUMBER(30) — Foreign key → lessonlist.LESSONLISTSEQ — NOT NULL

CUSTOMERS

  • CUSTOMERSEQ — NUMBER(30) — Primary key — NOT NULL
  • NAME — VARCHAR2(30) — NOT NULL
  • AGE — DATE
  • GENDER — VARCHAR2(30)
  • TRAINERID — VARCHAR2(50)
  • POINT — NUMBER(30)
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ — NOT NULL

EXERCISE

  • EXERCISESEQ — NUMBER(30) — Primary key — NOT NULL
  • EXERCISEDATE — DATE
  • EXERCISETYPE — VARCHAR2(30)
  • MEMBERSEQ — NUMBER(30) — NOT NULL
  • memo — varchar2(2000)
  • checked — varchar2(10)

FOOD

  • FOODSEQ — NUMBER(30) — Primary key — NOT NULL
  • FOODNAME — VARCHAR2(250)
  • CATEGORY — VARCHAR2(150)
  • CALORY — NUMBER(30) — NOT NULL
  • GRAM — NUMBER(30) — NOT NULL
  • carbohydrate — number
  • protein — number
  • fat — number
  • salt — number
  • mealmenuseq — NUMBER(30) — Foreign key → MEALMENU.mealmenuseq

LIKEANDRECOMMEND

  • likeandrecommendseq — number(30)
  • userseq — number(30) — NOT NULL
  • channelseq — number(30) — NOT NULL
  • trainerlike — number(30)
  • trainerrecommend — number(30)

MEALMENU

  • mealmenuseq — NUMBER(30) — Primary key — NOT NULL
  • MEALDATE — DATE
  • MENUWHEN — VARCHAR2(30)
  • MEMBERSEQ — NUMBER(30) — Foreign key → MEMBERLIST.MEMBERSEQ — NOT NULL
  • memo — varchar2(2000)
  • checked — varchar2(10)

MEMBERLIST

  • MEMBERSEQ — NUMBER(30) — Primary key — NOT NULL
  • CUSTOMERSEQ — NUMBER(30) — Foreign key → CUSTOMERS.CUSTOMERSEQ — NOT NULL
  • TRAINERSEQ — NUMBER(30) — Foreign key → TRAINER.TRAINERSEQ — NOT NULL
  • MEMBERLEVEL — NUMBER(30)

PAYMENT

  • PAYMENTSEQ — NUMBER(30) — Primary key — NOT NULL
  • pay — NUMBER(30)
  • lessonname — varchar2(50)
  • paydate — date
  • trainerseq — number(30)
  • customerseq — number(30)

REVIEWS

  • reviewseq — number(30)
  • channelseq — number(30)
  • userseq — number(30)
  • DEPTH — number(30)
  • CONTENT — varchar2(2000)
  • REGISTERDATE — date
  • star — number(30)

ROLE

  • ROLESEQ — NUMBER(30) — Primary key — NOT NULL
  • AUTHORITY — VARCHAR2(50)

TRAINER

  • TRAINERSEQ — NUMBER(30) — Primary key — NOT NULL
  • NAME — VARCHAR2(30) — NOT NULL
  • AGE — DATE
  • GENDER — VARCHAR2(30)
  • POINT — NUMBER(30)
  • LESSONTYPE — VARCHAR2(50)
  • RECOMMEND — NUMBER(30)
  • FEES — NUMBER(30)
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ — NOT NULL

TRAINING

  • TRAININGSEQ — NUMBER(30) — Primary key — NOT NULL
  • TRAININGNAME — VARCHAR2(50) — NOT NULL
  • TRAININGTYPE — VARCHAR2(50)
  • TRAININGTARGET — VARCHAR2(50)
  • TRAININGCOUNT — NUMBER(30)
  • TRAININGSET — NUMBER(30)
  • weightandtime — varchar2(100)
  • TRAININGDONE — VARCHAR2(50)
  • EXERCISESEQ — NUMBER(30) — Foreign key → EXERCISE.EXERCISESEQ — NOT NULL
  • LESSONLISTSEQ — NUMBER(30) — Foreign key → lessonlist.LESSONLISTSEQ
  • filesseq — number(30)

USER_BASIC

  • USERSEQ — NUMBER(30) — Primary key — NOT NULL
  • USERID — VARCHAR2(50) — NOT NULL
  • USERPW — VARCHAR2(50) — NOT NULL
  • USERDATE — DATE — NOT NULL
  • USEREMAIL — VARCHAR2(100)
  • USERKEY — VARCHAR2(50)

USER_ROLE

  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ — NOT NULL
  • ROLESEQ — NUMBER(30) — Foreign key → ROLE.ROLESEQ — NOT NULL

apply

  • applyseq — number(30) — Primary key — NOT NULL
  • applytype — VARCHAR2(50)
  • userseq — number(30) — NOT NULL

channel

  • channelSEQ — NUMBER(30) — Primary key — NOT NULL
  • TRAINERSEQ — NUMBER(30) — Foreign key → TRAINER.TRAINERSEQ — NOT NULL
  • WRITEDATE — DATE
  • TRAINERLIKE — NUMBER(30)
  • TRAINERRECOMMEND — NUMBER(30)

chatroom

  • chatroomseq — number — Primary key — NOT NULL
  • userseq1 — number
  • userseq2 — number
  • othersname — varchar2(30)
  • recentdate — date

files

  • filesSEQ — NUMBER(30) — Primary key — NOT NULL
  • SAVENAME — VARCHAR2(200)
  • ORINAME — VARCHAR2(100)
  • SAVEPATH — VARCHAR2(500)
  • CHATSEQ — NUMBER(30) — Foreign key → CHAT.CHATSEQ
  • TRAININGSEQ — NUMBER(30) — Foreign key → TRAINING.TRAININGSEQ
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ
  • LESSONLISTSEQ — NUMBER(30) — Foreign key → lessonlist.LESSONLISTSEQ
  • channelSEQ — NUMBER(30) — Foreign key → channel.channelSEQ
  • membercommentseq — number(30) — Foreign key → memberComment.membercommentseq
  • type — VARCHAR2(30)

lessonlist

  • LESSONLISTSEQ — NUMBER(30) — Primary key — NOT NULL
  • LESSONSCORE — NUMBER(30)
  • LESSONLIKE — NUMBER(30)
  • LESSONRECOMMEND — NUMBER(30)
  • LESSONPRICE — NUMBER(30)
  • LESSONNAME — VARCHAR2(50)
  • lessoncontent — varchar2(2000)
  • LESSONSTARTDATE — DATE
  • LESSONENDDATE — DATE
  • TRAINERSEQ — NUMBER(30) — Foreign key → TRAINER.TRAINERSEQ — NOT NULL
  • LESSONTYPE — VARCHAR2(50)
  • VIEWCOUNT — NUMBER(30)
  • channelSEQ — NUMBER(30) — Foreign key → channel.channelSEQ — NOT NULL
  • CATEGORYNAME — VARCHAR2(50)
  • MEMBERSEQ — NUMBER(30) — Foreign key → MEMBERLIST.MEMBERSEQ — NOT NULL
  • IMGFILE — NUMBER(30,0)
  • VIDEOFILE — NUMBER(30,0)

meal

  • mealseq — number(30) — NOT NULL
  • FOODSEQ — NUMBER(30)
  • mealmenuseq — NUMBER(30)
  • quantity — number
  • mealname — varchar2(250)

memberComment

  • membercommentseq — number(30) — Primary key — NOT NULL
  • comments — varchar2(2000)
  • membercommentdate — date
  • memberseq — number(30)
  • trainerseq — number(30)

qnaboard

  • QNASEQ — NUMBER(30)
  • USERSEQ — NUMBER(30) — Foreign key → USER_BASIC.USERSEQ
  • QTITLE — VARCHAR2(200) — NOT NULL
  • QCONTENT — VARCHAR2(2000) — NOT NULL
  • INDATE — DATE
  • QTYPE — VARCHAR2(20) — NOT NULL

qreply

  • qreplyseq — number(30)
  • qnaseq — number(30)
  • USERSEQ — number(30) — Foreign key → USER_BASIC.USERSEQ
  • depth — number(10) — NOT NULL
  • qreindate — date
  • qrecontent — varchar2(1000) — NOT NULL
  • qrename — varchar2(20)