기말과제

테이블 (11)

Board (Untitled2)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • CONTENT — TEXT

Comment (Untitled3)

  • ID — INT — 기본 키 — NOT NULL
  • POST_ID — INT — 외래 키 → Board.ID — NOT NULL
  • USER_ID (USER_ID2) — INT — 외래 키 → Board.USER_ID — NOT NULL
  • CONTENT — TEXT

Exercise (Untitled9)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • TYPE — VARCHAR(100)
  • TIME — INT
  • COUNT — INT
  • SCORE — INT

ExercisePlan (Untitled4)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • TYPE — VVARCHAR(100)
  • COUNT — INT
  • SET — INT
  • CHECK — TINYINT(1)

Follow (Untitled6)

  • ID — BIGINT — 기본 키 — NOT NULL
  • FOLLOWER_ID — INT — 외래 키 → User.ID — NOT NULL
  • FOLLOWING_ID — INT

Hashtag (Untitled7)

  • ID — BIGINT — 기본 키 — NOT NULL
  • POST_ID — INT — 외래 키 → Board.ID — NOT NULL
  • CONTENT — VARCHAR(100)

Images (Untitled8)

  • ID — BIGINT — 기본 키 — NOT NULL
  • POST_ID — INT — 외래 키 → Board.ID — NOT NULL
  • USER_ID — INT — 외래 키 → Board.USER_ID — NOT NULL
  • TYPE — VARCHAR(100)
  • URL — VARCHAR(255)

Nutrition (Untitled)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • NAME — VARCHAR(100)
  • BARCODE — INT
  • MANUFACTURER — VARCHAR(100)
  • SIZE — VARCHAR(100)
  • CALORIE — DOUBLE
  • CHO — DOUBLE
  • PROTEIN — DOUBLE
  • FAT — DOUBLE
  • SUGARS — DOUBLE
  • SALT — DOUBLE
  • CHOLE — DOUBLE
  • SATUR_FAT — DOUBLE
  • TRANS_FAT — DOUBLE

NutritionPlan (Untitled10)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • NAME — VARCHAR(100)
  • CALORIE — DOUBLE
  • PROTEIN — DOUBLE
  • FAT — DOUBLE
  • CHO — DOUBLE
  • CHECK — TINYINT(1)

Status (Untitled11)

  • ID — INT — 기본 키 — NOT NULL
  • USER_ID — INT — 외래 키 → User.ID — NOT NULL
  • AGE — INT
  • HEIGHT — FLOAT
  • WEIGHT — FLOAT
  • DISEASE — VARCHAR(255)
  • ALLERGY — VARCHAR(255)

User (Untitled5)

  • ID — INT — 기본 키 — NOT NULL
  • EMAIL — VARCHAR(100)
  • PASSWORD — VARCHAR(100)
  • NAME — VARCHAR(100)
  • GENDER — TINYINT(1)
  • PHONE — VARCHAR(72)
  • SALT — VARCHAR(100)
  • SNS_ID — VARCHAR(100)