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