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