웹프

테이블 (3)

LIST (Untitled2)

  • LIST_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • LIST_TODO (Field) — VARCHAR(100)
  • LIST_DATE (Field2) — DATE
  • LIST_START (Field3) — TIMESTAMP
  • LIST_END (Field5) — TIMESTAMP
  • LIST_DONE (Field4) — BOOLEAN

TODO (Untitled4)

  • USER_ID — VARCHAR(20) — 외래 키 → USER.USER_ID — NOT NULL
  • LIST_ID (Key) — NUMBER — 외래 키 → LIST.LIST_ID — NOT NULL

USER (Untitled)

  • USER_ID — VARCHAR(20) — 기본 키 — NOT NULL
  • USER_NAME (Field) — VARCHAR(20)
  • USER_BIRTH (Field4) — VARCHAR(20)
  • USER_PASSWORD (Field2) — VARCHAR(50)
  • USER_EMAIL (Field3) — VARCHAR(50)