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