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 (분할)

Untitled9

    YOOSAN (Untitled13)

    • YOONAME (Field) — VARCHAR(50)
    • KCAL (Field2) — VARCHAR(50)
    • TIMES (Field3) — VARCHAR(50)
    • IMG (Field4) — VARCHAR(100)