jaeil

Tables (9)

BOARD (Untitled2)

  • BOARDNO (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • CONTENT (Field2)
  • DATE (Field3)
  • READCOUNT (Field4)
  • TYPE (Field5)
  • MEMBERNO (Key2) — Foreign key → MEMBER.MEMBERNO — NOT NULL

FILE (Untitled4)

  • FILENO (Key) — Primary key — NOT NULL
  • ROUTE (Field)
  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL

HEART (Untitled6)

  • MEMBERNO (Key) — Foreign key → MEMBER.MEMBERNO — NOT NULL
  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL

IMG (Untitled9)

  • IMGNO (Key) — Primary key — NOT NULL
  • BOARDNO (Field)
  • ORIGINALFILENAME (Field2)
  • RENAMEFILENAME (Field3)
  • SAVEPATH (Field4)
  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL

MATERIAL (Untitled5)

  • MATERIALNAME (Key) — Primary key — NOT NULL
  • FAT (Field)
  • PROTEIN (Field2)
  • CARBOHYDRATE (Field3)
  • CALORIE (Field4)

MEMBER (Untitled)

  • MEMBERNO (Key) — Primary key — NOT NULL
  • ID (Field)
  • PW (Field2)
  • NAME (Field3)
  • EMAIL (Field4)
  • PHONE (Field5)
  • POINT (Field6)

RECEPIE (Untitled8)

  • MATERIALNAME (Key) — Foreign key → MATERIAL.MATERIALNAME — NOT NULL
  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL

REVIEWBOARD (Untitled3)

  • REVBOARDNO (Key) — Primary key — NOT NULL
  • REVCONTENT (Field2)
  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL
  • MEMBERNO (Key3) — Foreign key → MEMBER.MEMBERNO — NOT NULL
  • REG_DATE (Field)

STORE (Untitled7)

  • BOARDNO (Key2) — Foreign key → BOARD.BOARDNO — NOT NULL
  • 위도 (Field)
  • 경도 (Field2)
  • STORENAME (Field3)
  • ARRD (Field4)