To Do List
Tables (5)
Card
- CARD_NO — INT(10) — Primary key — NOT NULL
- MEMBER_NO — INT(10) — Foreign key → Member.MEMBER_NO — NOT NULL
- CARD_TITLE — VARCHAR(50)
- CARD_DONE — INT(1) — NOT NULL
- CARD_CREATETIME — TIMESTAMP — NOT NULL
Card_Line
- LINE_NO — INT(10) — Primary key — NOT NULL
- CARD_NO — INT(10) — Foreign key → Card.CARD_NO — NOT NULL
- CARD_LINE_CHECKED — INT(1) — NOT NULL
- CARD_LINE_VALUE — VARCHAR(1000)
Friend
- MEMBER_NO — INT(10) — Foreign key → Member.MEMBER_NO — NOT NULL
- FRIEND_MEMBER_NO — INT(10) — NOT NULL
- FRIEND_CREATETIME — TIMESTAMP — NOT NULL
Member
- MEMBER_NO — INT(10) — Primary key — NOT NULL
- MEMBER_EMAIL — VARCHAR(50) — NOT NULL
- MEMBER_PWD — VARCHAR(30) — NOT NULL
- MEMBER_NAME — VARCHAR(20) — NOT NULL
- MEMBER_NICKNAME — VARCHAR(20) — NOT NULL
- MEMBER_CREATETIME — TIMESTAMP — NOT NULL
Shared
- CARD_NO — INT(10) — Foreign key → Card.CARD_NO — NOT NULL
- SHARED_MEMBER_NO (MEMBER_NO) — INT(10) — Foreign key → Member.MEMBER_NO — NOT NULL
- SHARED_DONE — INT(1) — NOT NULL