test1

Tables (4)

CODY (Untitled2)

  • C_CODE (Key) — Primary key — NOT NULL
  • M_CODE (Key2) — Foreign key → MEMBER.M_CODE — NOT NULL
  • DATE (Field)
  • TEMP (Field2)
  • WEATHER (Field3)
  • MOOD (Field4)
  • CONTENTS (Field5)
  • VIEW_CNT (Field6)
  • LIKE_CNT (Field7)
  • IMG (Field8)

COMENT (Untitled3)

  • COM_CODE (Key) — Primary key — NOT NULL
  • C_CODE (Key2) — Foreign key → CODY.C_CODE — NOT NULL
  • M_CODE (Key3) — Foreign key → MEMBER.M_CODE — NOT NULL
  • TIME_STAMP (Field)
  • DELETE_NY (Field2)
  • CONTENTS (Field3)

MEMBER (Untitled)

  • M_CODE (Key) — Primary key — NOT NULL
  • ID (Field)
  • PW (Field2)
  • NAME (Field3)
  • E_MAIL (Field4)
  • PHONE (Field5)
  • NICK_NAME (Field6)

RECOMENT (Untitled4)

  • RECOM_CODE (Key) — Primary key — NOT NULL
  • COM_CODE (Key2) — Foreign key → COMENT.COM_CODE — NOT NULL
  • M_CODE (Key3) — Foreign key → MEMBER.M_CODE — NOT NULL
  • TIME_STAMP (Field)
  • DELETE_NY (Field2)
  • CONTENTS (Field3)