capston-debug

Tables (5)

board

  • id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.id — NOT NULL
  • board_image_id — BIGINT — Foreign key → board_image.id — NOT NULL
  • content — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL

board_image

  • id — BIGINT — Primary key — NOT NULL
  • origin_name — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(255) — NOT NULL

issue

  • board_image_id — BIGINT — Foreign key → board_image.id — NOT NULL
  • disease_type — VARCHAR — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(30) — NOT NULL
  • name — VARCHAR(20 — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL

project

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • name — VARCHAR(25) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • crop_type — VARCHAR(25) — NOT NULL
  • is_completed — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL