PesnalProject
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
- MEMBER_ID (Key3) — INT — Foreign key → MEMBER.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
- MEMBER_ID (Key4) — INT — Foreign key → MEMBER.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)