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