wise my life

Tables (11)

Achieve (Untitled5)

  • achieve_idx (Key) — varchar(20) — Primary key — NOT NULL
  • condition_idx (Key2) — varchar(20) — Foreign key → Achieve_condition.condition_idx — NOT NULL
  • name (Field) — varchar(20)
  • difficulty (Field2) — varchar(20)

Achieve_condition (Untitled6)

  • condition_idx (Key) — varchar(20) — Primary key — NOT NULL
  • get_date (Field) — varchar(12)
  • get_check (Field2) — varchar(1)
  • use_achieve (Field3) — varchar(1)

Comment (Untitled4)

  • comment_idx (Key) — varchar(20) — Primary key — NOT NULL
  • post_idx (Key2) — varchar(20) — Foreign key → Post.post_idx — NOT NULL
  • create_id (Field) — varchar(20)
  • create_date (Field3) — varchar(12)
  • update_id (Field4) — varchar(20)
  • update_date (Field7) — varchar(12)
  • content (Field5) — varchar(100)
  • like (Field6) — varchar(20)

Dday (Untitled10)

  • Dday_idx (Key) — varchar(20) — Primary key — NOT NULL
  • check (Field) — varchar(1)
  • time (Field2) — varchar(12)

Manage_schedule (Untitled7)

  • schedule_idx (Key) — varchar(20) — Primary key — NOT NULL
  • sIcon_idx (Key2) — varchar(20) — Foreign key → Schedule_icon.sIcon_idx — NOT NULL
  • notification_idx (Key3) — varchar(20) — Foreign key → Notification.notification_idx — NOT NULL
  • Dday_idx (Key4) — varchar(20) — Foreign key → Dday.Dday_idx — NOT NULL
  • create_id (Field) — varchar(20)
  • create_date (Field2) — varchar(12)
  • update_id (Field3) — varchar(20)
  • update_date (Field4) — varchar(12)
  • kind (Field5) — varchar(1)
  • title (Field6) — varchar(100)
  • content (Field7) — varchar(100)
  • color (Field9) — varchar(20)
  • standard (Field10) — varchar(100)
  • start_date (Field11) — varchar(12)
  • end_date (Field12) — varchar(12)
  • repeat_check (Field13) — varchar(1)

Member (Untitled3)

  • member_idx (Key) — varchar(20) — Primary key — NOT NULL
  • achieve_idx (Key3) — varchar(20) — Foreign key → Achieve.achieve_idx — NOT NULL
  • condition_idx (Key22) — varchar(20) — Foreign key → Achieve.condition_idx — NOT NULL
  • scrap_idx (Key2) — varchar(20) — Foreign key → Scrap.scrap_idx — NOT NULL
  • agree_idx (Key4) — varchar(20) — Foreign key → Member_agree.agree_idx — NOT NULL
  • post_idx (Key5) — varchar(20) — Foreign key → Post.post_idx — NOT NULL
  • name (Field) — varchar(20)
  • create_date (Field3) — varchar(12)
  • update_date (Field4) — varchar(12)
  • profile_img (Field2) — varchar(100)

Member_agree (Untitled8)

  • agree_idx (Key) — varchar(20) — Primary key — NOT NULL
  • update_date (Field5) — varchar(12)
  • push_agree (Field) — varchar(1)
  • night_agree (Field4) — varchar(1)

Notification (Untitled9)

  • notification_idx (Key) — varchar(20) — Primary key — NOT NULL
  • check (Field) — varchar(1)
  • time (Field2) — varchar(12)

Post (Untitled2)

  • post_idx (Key) — varchar(20) — Primary key — NOT NULL
  • title (Field) — varchar(20)
  • content (Field2) — varchar(1000)
  • create_id (Field4) — varchar(20)
  • create_date (Field5) — varchar(12)
  • update_id (Field6) — varchar(20)
  • update_date (Field9) — varchar(12)
  • like (Field7) — varchar(20)
  • post_img (Field3) — varchar(100)

Schedule_icon (Untitled)

  • sIcon_idx (Key) — varchar(20) — Primary key — NOT NULL
  • title (Field2) — varchar(20)
  • img (Field) — varchar(100)

Scrap (Untitled11)

  • scrap_idx (Key) — varchar(20) — Primary key — NOT NULL
  • post_idx (Key2) — varchar(20) — Foreign key → Post.post_idx — NOT NULL
  • scrap (Field) — varchar(20)