Health
Tables (17)
AEROBIC (Untitled11)
- PART (Field) — VARCHAR(20)
- RWEIGHT (Field2) — INT
- LINK (Field3) — VARCHAR(100)
- ENAME (Field4) — VARCHAR(40)
CENTER (Untitled16)
- CSEQ (Key) — INT — Primary key — NOT NULL
- CNAME (Field) — VARCHAR(100)
- CADDR (Field2) — VARCHAR(200)
- CPHONE (Field3) — VARCHAR(100)
- CSCORE (Field4) — VARCHAR(30)
COMMENTS (Untitled6)
- COMMENTNO (Key) — INT — Primary key — NOT NULL
- POSTNO (글번호) — INT — Foreign key → POST.POSTNO — NOT NULL
- USERID (UNIQUE) — VARCHAR(50) — Foreign key → USERS.USERID — NOT NULL
- CONTENT (Field3) — VARCHAR(150)
- REGDATE (Field) — TIMESTAMP
- Field2
FOOD (Untitled15)
- FNAME (Field) — VARCHAR(22)
- PROTEIN (Field2) — DOUBLE
LIKES (Untitled7)
- LIKENO (Key) — INT — Primary key — NOT NULL
- POSTNO (글번호) — INT — Foreign key → POST.POSTNO — NOT NULL
- USERNO (PK) — INT — Foreign key → POST.USERNO — NOT NULL
MOOSAN (Untitled12)
- MOONAME (Field) — VARCHAR(50)
- KCAL (Field2) — VARCHAR(50)
- NUMBERS (Field3) — VARCHAR(50)
- IMG (Field4) — VARCHAR(100)
POST (Untitled2)
- POSTNO (글번호) — INT — Primary key — NOT NULL
- USERNO (PK) — INT — Foreign key → USERS.USERNO — NOT NULL
- USERID (UNIQUE) — VARCHAR(50) — Foreign key → USERS.USERID — NOT NULL
- CONTENT (내용) — VARCHAR(150)
- IMG (이미지) — VARCHAR(100)
- REGDATE (등록날짜) — TIMESTAMP
- TAGNAME (태그) — VARCHAR(50)
PRESS (Untitled5)
- ENAME (Field) — VARCHAR(40)
- PART (Field2) — VARCHAR(20)
- DIFFICULTY (Field3) — INT
- RWEIGHT (Field4) — INT
- LINK (Field5) — VARCHAR(200)
PROFILE (Untitled8)
- PROFILENO (Key) — INT — Primary key — NOT NULL
- USERNO (PK) — INT — Foreign key → USERS.USERNO — NOT NULL
- IMG (Field) — VARCHAR(100)
PULL (Untitled4)
- ENAME (Field) — VARCHAR(40)
- PART (Field2) — VARCHAR(20)
- DIFFICULTY (Field3) — INT
- RWEIGHT (Field4) — INT
- LINK (Field5) — VARCHAR(200)
RECIPE (Untitled14)
- RECIPENO (Key) — INT — Primary key — NOT NULL
- FNAME (Field) — VARCHAR(50)
- FIMG (Field2) — VARCHAR(100)
- LINK (Field3) — VARCHAR(100)
ROUTINE (Untitled3)
- USERID (UNIQUE) — VARCHAR(50) — Foreign key → USERS.USERID — NOT NULL
- ENAME (운동이름) — VARCHAR(40)
- GENDER (성별) — VARCHAR(10)
- RWEIGHT (중량) — INT
- PART (Field) — INT
- PARTA (Field2) — INT
- PARTB (Field3) — INT
- PARTC (Field4) — INT
- PARTD (Field5) — INT
- PARTE (Field6) — INT
- HEIGHT (Field7) — DOUBLE(3,1)
- WEIGHT (Field8) — DOUBLE(3,1)
- FAT (Field9) — DOUBLE(2,1)
- MUSCLE (Field10) — DOUBLE(2,1)
- CAREER (Field11) — INT
- DIVISION (Field12) — INT
- LINK (Field13) — VARCHAR(200)
TAG\ (Untitled10)
- TAGNO (Key) — INT — Primary key — NOT NULL
- POSTNO (글번호) — INT — Foreign key → POST.POSTNO — NOT NULL
- TAGNAME (Field) — VARCHAR(100)
TODO (Untitled17)
- USERID (UNIQUE) — VARCHAR(50) — Foreign key → USERS.USERID — NOT NULL
- DAYS (Field) — TIMESTAMP
- EXISTW (Field2) — VARCHAR(50)
- GOALW (Field3) — VARCHAR(50)
- GOALD (Field4) — VARCHAR(50)
- ATTENDENCE (Field5)
USERS (Untitled)
- USERNO (PK) — INT — Primary key — NOT NULL
- USERID (UNIQUE) — VARCHAR(50) — Primary key — NOT NULL
- PASSWORD (비밀번호) — VARCHAR(30)
- UNAME (유저이름) — VARCHAR(30)
- AGE (나이) — VARCHAR(30)
- GENDER (성별) — VARCHAR(30)
- HEIGHT (키) — VARCHAR(30)
- WEIGHT (몸무게) — VARCHAR(30)
- FAT (체지방량) — VARCHAR(30)
- MUSCLE (근육량) — VARCHAR(30)
- CAREER (경력) — INT
- DIVISION (분할)
YOOSAN (Untitled13)
- YOONAME (Field) — VARCHAR(50)
- KCAL (Field2) — VARCHAR(50)
- TIMES (Field3) — VARCHAR(50)
- IMG (Field4) — VARCHAR(100)