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)