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