loveDiary
Tables (6)
Attachment
- attm_no — number — Primary key — NOT NULL
- Field (attm_status) — char(1) — NOT NULL
- Field2 (attm_level) — number — NOT NULL
- Field (attm_rename_n ame) — varchar2(50) — NOT NULL
- Field (attm_original_name) — varchar2(50) — NOT NULL
- diary_no — number — Foreign key → Diary.diary_no — NOT NULL
Couple
- couple_no — number — Primary key — NOT NULL
- date_date — date — NOT NULL
- mbId1 — varchar2(30) — Foreign key → Member.mb_Id — NOT NULL
- mbId2 — varchar2(30) — Foreign key → Member.mb_Id — NOT NULL
Diary
- diary_no — number — Primary key — NOT NULL
- diary_title — varchar2(100)
- diary_date — date — NOT NULL
- diary_content — varchar2(1000)
- mbId — varchar2(30) — Foreign key → Member.mb_Id — NOT NULL
Event
- event_no — number — Primary key — NOT NULL
- event_title — varchar2(100)
- event_content — varchar2(500)
- event_date — date
- event_type — char(1)
- mbId — varchar2(30) — Foreign key → Member.mb_Id — NOT NULL
Member
- mb_Id — varchar2(30) — Primary key — NOT NULL
- mb_Pwd — varchar2(30) — NOT NULL
- mb_NickName — varchar2(30) — NOT NULL
- profile — varchar2(100)
- 생일 (birthday) — date — NOT NULL
Notification
- noti_number — number — Primary key — NOT NULL
- noti_type — char(1)
- noti_date — date
- mbId — varchar2(30) — Foreign key → Member.mb_Id — NOT NULL