ホンギピョ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)