TodoList

Tables (4)

COMMENT (comment)

  • COMMENT_SEQ (comment_seq) — NUMBER(12, 0) — Primary key — NOT NULL
  • COMMUNITY_SEQ (community_seq) — NUMBER(12, 0) — Foreign key → COMMUNITY.COMMUNITY_SEQ — NOT NULL
  • MEMBER_ID (member_id) — VARCHAR2(20) — Foreign key → Member.MEMBER_ID — NOT NULL
  • COMMENT_CONTENT (comment_content) — VARCHAR2(200)
  • COMMENT_DATE (comment_date) — VARCHAR2(30)

COMMUNITY (community)

  • COMMUNITY_SEQ (community_seq) — NUMBER(12, 0) — Primary key — NOT NULL
  • MEMBER_ID (member_id) — VARCHAR2(20) — Foreign key → Member.MEMBER_ID — NOT NULL
  • COMMUNITY_TITLE (community_title) — VARCHAR2(20)
  • COMMUNITY_CONTENT (community_content) — VARCHAR2(200)
  • COMMUNITY_CNT (community_cnt) — NUMBER(12,0)
  • COMMUNITY_DATE (community_date) — VARCHAR2(30)

Member (member)

  • MEMBER_ID (member_id) — VARCHAR2(20) — Primary key — NOT NULL
  • MEMBER_PW (member_pw) — VARCHAR2(20)
  • MEMBER_NICK (member_nick) — VARCHAR2(20)

TODO (todo)

  • TODO_SEQ (todo_seq) — NUMBER(12, 0) — Primary key — NOT NULL
  • MEMBER_ID (member_id) — VARCHAR2(20) — Foreign key → Member.MEMBER_ID — NOT NULL
  • TODO_CONTENT (todo_content) — VARCHAR2(200)
  • TODO_DATE (todo_date) — VARCHAR2(30)
  • TODO_CHECK (todo_check) — VARCHAR2(20)