운동 chill guy

테이블 (4)

Board (board)

  • ID (PK) — INT — 기본 키 — NOT NULL
  • user_id (FK) — INT — 외래 키 → User.ID — NOT NULL
  • title (Field2) — VARCHAR(200)
  • content (Field3) — TEXT
  • created_at (Field4) — DATETIME

Comment (comment)

  • ID (Key) — INT — 기본 키 — NOT NULL
  • board_id (FK) — INT — 외래 키 → Board.user_id — NOT NULL
  • user_id (FK1) — INT — 외래 키 → User.ID — NOT NULL
  • content (Field3) — TEXT
  • created_at (Field5) — DATETIME

Diary (diary)

  • ID (PK) — INT — 기본 키 — NOT NULL
  • user_id (FK) — INT — 외래 키 → User.ID — NOT NULL
  • weight (Field3) — INT
  • reqs (Field5) — INT
  • sets (Field4) — INT
  • date (Field2) — datetime
  • exercise (Field) — VACHAR(200)
  • checked (Field6) — boolean

User (users)

  • ID (Key) — INT — 기본 키 — NOT NULL
  • email (Field) — VARCHAR(100) — 이메일(로그인용)
  • password (Field2) — VARCHAR(200)
  • nickname (Field3) — VARCHAR(100)