PESONALPROJECT

Tables (5)

BOARD_MYCAT (Untitled2)

  • BOARD_MYCAT_ID (Key) — INT — Primary key — NOT NULL
  • MEMBER_ID (Key2) — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • BOARD_MYCAT_TITLE (Field) — VARCHAR(200)
  • BOARD_MYCAT_CONTENT (Field2) — TEXT
  • BOARD_MYCAT_HIT (Field3) — INT
  • BOARD_MYCAT_DATE (Field4) — DATETIME

BOARD_Q&A (Untitled4)

  • BOARD_MYCAT_ID (Key) — INT — Primary key — NOT NULL
  • MEMBER_ID (Key3) — INT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • BOARD_Q&A_TITLE (Field) — VARCHAR(200)
  • BOARD_Q&A_CONTENT (Field2) — TEXT
  • BOARD_Q&A_HIT (Field3) — INT
  • BOARD_Q&A_DATE (Field4) — DATETIME

COMMENT_MYCAT (Untitled3)

  • COMMENT_MYCAT_ID (Key) — INT — Primary key — NOT NULL
  • BOARD_MYCAT_ID (Key2) — INT — Foreign key → BOARD_MYCAT.BOARD_MYCAT_ID — NOT NULL
  • MEMBER_ID (Key22) — INT — Foreign key → BOARD_MYCAT.MEMBER_ID — NOT NULL
  • COMMENT_MYCAT_CONTENT (Field) — VARCHAR(500)
  • COMMENT_MYCAT_DATE (Field2) — DATETIME
  • BOARD_MYCAT_ID (Field3) — INT

COMMENT_Q&A (Untitled5)

  • COMMENT_Q&A_ID (Key) — INT — Primary key — NOT NULL
  • BOARD_MYCAT_ID (Key2) — INT — Foreign key → BOARD_Q&A.BOARD_MYCAT_ID — NOT NULL
  • MEMBER_ID (Key3) — INT — Foreign key → BOARD_Q&A.MEMBER_ID — NOT NULL
  • COMMENT_Q&A_CONTENT (Field) — VARCHAR(500)
  • COMMENT_Q&A_DATE (Field2) — DATETIME
  • BOARD_Q&A_ID (Field3) — INT

MEMBER (Untitled)

  • MEMBER_ID (Key) — INT — Primary key — NOT NULL
  • MEMBER_LOGINID (Field) — VARCHAR(50)
  • MEMBER_NAME (Field2) — VARCHAR(100)
  • MEMBER_EMAIL (Field3) — VARCHAR(200)
  • MEMBER_PWD (Field4) — VARCHAR(300)
  • MEMBER_PHONE (Field5) — VARCHAR(20)
  • MEMBER_PET (Field6) — VARCHAR(100)