ToDo
Tables (3)
comments (댓글)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Field) — bigint — Foreign key → user.id — NOT NULL
- todos_id (Field2) — bigint — Foreign key → todos.id — NOT NULL
- comment (Field3) — text
- created_date (Field4) — datetime
- modified_date (Field5) — datetime
todos (투두)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Field) — bigint — Foreign key → user.id — NOT NULL
- title (Field2) — varchar(255)
- content (Field3) — text
- writer (Field4) — varchar(255)
- view (Field5) — bigint
- created_date (Field6) — datetime
- modified_date (Field7) — datetime
user (유저)
- id (Key) — bigint — Primary key — NOT NULL
- username (Field) — varchar(255)
- password (Field2) — varchar(255)
- nickname (Field3) — varchar(255)
- email (Field4) — varchar(255)
- created_date (Field5) — datetime
- modified_date (Field6) — datetime