HASH
Tables (6)
BOARD (Untitled2)
- BoardID (PK) — INT — Primary key — NOT NULL — AUTO_INCREMENT 옵션
- Title (Field) — VARCHAR(30) — NOT NULL
- Descript (Field2) — TEXT — NOT NULL
- Photo (Field3) — BINARY
- DATE (Field6) — DATETIME — NOT NULL
- MemberId (FK1) — VARCHAR(20) — Foreign key → MEMBER.MemberId — NOT NULL
- name (FK2) — VARCHAR(10) — Foreign key → MEMBER.MemberId — NOT NULL
- CategoriesID (PK2) — INT — Foreign key → Categories.CategoriesID — NOT NULL — AUTO_INCREMENT 옵션
- FILEID (PK3) — INT — Foreign key → FILE.FILEID — NOT NULL — AUTO_INCREMENT 옵션
COMMENT (Untitled5)
- comentid (PK) — INT — Primary key — NOT NULL — AUTO_INCREMENT 옵션
- boardid (FK) — INT — NOT NULL — AUTO_INCREMENT 옵션
- decription (Field) — TEXT — NOT NULL
- memid (PK2) — VARCHAR(20) — NOT NULL
- Date (Field2) — DATETIME — NOT NULL
- BoardID (PK3) — INT — Foreign key → BOARD.BoardID — NOT NULL — AUTO_INCREMENT 옵션
Categories (Untitled3)
- CategoriesID (PK) — INT — Primary key — NOT NULL — AUTO_INCREMENT 옵션
- Categories (Field) — INT — NOT NULL
FILE (Untitled4)
- FILEID (PK) — INT — Primary key — NOT NULL — AUTO_INCREMENT 옵션
- FILEORINAME (Field3) — TEXT — NOT NULL
- FILENAME (Field) — TEXT — NOT NULL
- FILEPATH (Field2) — TEXT — NOT NULL
MEMBER (Untitled)
- MemberId (PK) — VARCHAR(20) — Primary key — NOT NULL
- pw (Field) — VARCHAR(20) — NOT NULL
- name (Field2) — VARCHAR(10) — NOT NULL
- studentId (Field3) — VARCHAR(8) — NOT NULL
- email (Field4) — VARCHAR(50) — NOT NULL
- phone (Field5) — VARCHAR(11)
- level (Field6) — NOT NULL — CHECK 옵션 관리자,운영진,부원, 일반회원
MYpage (Untitled6)
- MemberId (PK2) — VARCHAR(20) — Foreign key → MEMBER.MemberId — NOT NULL
- Birth (Field) — DATE
- Interests (Field2) — VARCHAR(10)
- Coin (Field3) — INT — NOT NULL
- Warning (Field4) — INT — NOT NULL
- Profile (Field5) — TEXT — NOT NULL