Ediary

Tables (4)

T_DIARY (다이어리)

  • DIARY_NO — NUMBER — Primary key — NOT NULL
  • USER_NO — NUMBER — Foreign key → T_USER.USER_NO — NOT NULL
  • FILE_NO — NUMBER
  • CONTENT — VARCHAR2(4000)
  • REG_DT — DATE
  • DEL_YND (DEL_YN) — CHAR(1)

T_FILE (파일)

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • DIARY_NO — NUMBER — Foreign key → T_DIARY.DIARY_NO — NOT NULL
  • USER_NO — NUMBER — Foreign key → T_DIARY.USER_NO — NOT NULL
  • FILE_NM — VARCHAR2(200)
  • FILE_ST_NM — VARCHAR2(200)
  • SIZE — NUMBER

T_TODO (할 일)

  • TODO_NO — NUMBER — Primary key — NOT NULL
  • USER_NO — NUMBER — Foreign key → T_USER.USER_NO — NOT NULL
  • TEXT — VARCHAR2(256)
  • REG_DT — DATE
  • DEL_YN — CHAR(1)
  • COMPLETE_YN — CHAR(1)

T_USER (사용자)

  • USER_NO — NUMBER — Primary key — NOT NULL
  • USER_ID — VARCHAR2(50)
  • EMAIL — VARCHAR2(200)
  • PASSWORD — VARCHAR2(50)