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