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)