exchange-diary

Tables (4)

diary (Untitled2)

  • diary_idx (Key) — Primary key — NOT NULL
  • user_idx (Key22) — Foreign key → diary_content.user_idx — NOT NULL
  • group_idx (Key2) — Foreign key → group.group_idx — NOT NULL
  • user_idx (Key23) — Foreign key → group.user_idx — NOT NULL
  • diary_name (Field)
  • diary_cover (Field2)
  • diary_inpage (Field3)
  • diary_circle (Field4)

diary_content (Untitled3)

  • diary_content_idx (Key) — Primary key — NOT NULL
  • user_idx (Key2) — Foreign key → user.user_idx — NOT NULL
  • diary_idx (Field)
  • diary_content (Field2)
  • user_idx (Field3)

group (Untitled)

  • group_idx (Key) — Primary key — NOT NULL
  • user_idx (Key2) — Foreign key → user.user_idx — NOT NULL
  • group_write_order (Field2)
  • is_group_head (Field3)

user (-)

  • user_idx (Key) — Primary key — NOT NULL
  • user_id (Field)
  • user_pw (Field2)
  • user_name (Field3)
  • user_email (Field4)
  • user_img_url (Field5)
  • user_member_id (Field6)