myMindView

Tables (5)

LIKE

  • Key (CNT) — INT — Primary key — NOT NULL
  • Key (POST_ID) — INT — Foreign key → POSTS.Key — NOT NULL
  • Key (MEM_ID) — INT — Foreign key → POSTS.Key — NOT NULL

MEMBER

  • Key (MEM_ID) — INT — Primary key — NOT NULL
  • Field (ID) — VARCHAR(40)
  • Field (PW) — VARCHAR(40) — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (PHONE) — VARCHAR(10) — NOT NULL
  • Field (BIRTH) — VARCHAR(10) — NOT NULL
  • Field (GENDER) — VARCHAR(2) — NOT NULL

PHOTO

  • Key (PHOTO_ID) — INT — Primary key — NOT NULL
  • Key (POST_ID) — INT — Foreign key → POSTS.Key — NOT NULL
  • Field (PATH) — VARCHAR(100)
  • Field (FILENAME) — VARCHAR(40)
  • Field (FILESIZE) — INT

POSTS

  • Key (POST_ID) — INT — Primary key — NOT NULL
  • Key (MEM_ID) — INT — Foreign key → MEMBER.Key — NOT NULL
  • Field (HEAD) — VARCHAR(100) — NOT NULL
  • Field (BODY) — VARCHAR(1000)
  • Field (SECRET) — INT(1)
  • Field (DATE) — DATE
  • Field (HITS) — INT

REPLY

  • Key (REPLY_ID) — INT — Primary key — NOT NULL
  • Key (POST_ID) — INT — Foreign key → POSTS.Key — NOT NULL
  • Key (MEM_ID) — INT — Foreign key → POSTS.Key — NOT NULL
  • Field (CONTENT) — VARCHAR(500)
  • Field (DATED) — DATE