Todo
Tables (9)
Comment_security (댓글_시큐리티)
- comment_id (댓글_id) — bigserial — Primary key — NOT NULL
- todo_id (투두_id2) — bigserial — Foreign key → Todo_security.todo_id — NOT NULL
- member_id (아이디) — bigserial — Foreign key → Todo_security.member_id — NOT NULL
- comment (댓글) — text
- password (비밀번호) — text
Comment_step2 (댓글_스텝2)
- comment_id (댓글_id) — bigserial — Primary key — NOT NULL
- todo_id (투두_id2) — bigserial — Foreign key → Todo_step2.todo_id — NOT NULL
- comment (댓글) — text
- writer (작성자) — text
- password (비밀번호) — text
Copy Of Comment_security (CopyOf댓글_시큐리티)
- comment_id (댓글_id) — bigserial — Primary key — NOT NULL
- comment (댓글) — text
- password (비밀번호) — text
Copy Of Todo_security (CopyOf투두_시큐리티)
- todo_id (투두_id) — bigserial — Primary key — NOT NULL
- title (제목) — text
- content (내용) — text
- date (날짜) — timestamp
- achievement (달성여부) — boolean
Member (멤버)
- member_id (아이디) — bigserial — Primary key — NOT NULL
- account (계정) — text
- password (비밀번호) — text
- role (역할) — text
Member (CopyOf멤버)
- member_id (아이디) — bigserial — Primary key — NOT NULL
- account (계정) — text
- password (비밀번호) — text
- role (역할) — text
Todo_security (투두_시큐리티)
- todo_id (투두_id) — bigserial — Primary key — NOT NULL
- member_id (아이디) — bigserial — Foreign key → Member.member_id — NOT NULL
- title (제목) — text
- content (내용) — text
- date (날짜) — timestamp
- achievement (달성여부) — boolean
Todo_step1 (투두_스텝1)
- todo_id (투두_id) — bigserial — Primary key — NOT NULL
- title (제목) — text
- content (내용) — text
- date (날짜) — timestamp
- writer (작성자) — text
Todo_step2 (투두_스텝2)
- todo_id (투두_id) — bigserial — Primary key — NOT NULL
- title (제목) — text
- content (내용) — text
- date (날짜) — timestamp
- writer (작성자) — text
- achievement (달성여부) — boolean