Cafe
Tables (11)
Area
- id — INT — Primary key — NOT NULL
- name — VARCHAR(10)
- TYPE — INT
Cafe
- id — int — Primary key — NOT NULL
- GroupId (Key) — INT — Foreign key → CafeGroup.id — NOT NULL
- Name — VARCHAR(20)
- MasterId — INT
- CafeURL — VARCHAR(100)
- IconURL — VARCHAR(100)
- IsOpen — INT
- NameType (Field) — INT
- FirstClassID — INT
- SecondClassID — INT
- Content — longtext
- Area — VARCHAR(20)
- DATE — DATETIME
CafeBoard
- id — INT — Primary key — NOT NULL
- cafeid — INT — Foreign key → Cafe.id — NOT NULL
- name — VARCHAR(20)
- needlevel — INT
- type — INT
- date — DATETIME
CafeGroup
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- DATE — DATETIME
- Field
CafeMember
- id — INT — Primary key — NOT NULL
- Cafeid — INT — Foreign key → Cafe.id — NOT NULL
- nickname — VARCHAR(20)
- visitcount — INT
- level — INT
- date — DATETIME
CafePost
- id — INT — Primary key — NOT NULL
- userid — INT — Foreign key → User.id — NOT NULL
- boardid — INT — Foreign key → CafeBoard.id — NOT NULL
- type — INT
- date — DATETIME
- cafeid — INT
- Content — longtext
- title — VARCHAR(100)
Category
- id — INT — Primary key — NOT NULL
- LEVEL — INT
Comment
- id — INT — Primary key — NOT NULL
- postid — INT — Foreign key → CafePost.id — NOT NULL
- userid — INT — Foreign key → User.id — NOT NULL
- cafeid — INT
- date — DATETIME
Keyword
- id — INT — Primary key — NOT NULL
- CafeID — int — Foreign key → Cafe.id — NOT NULL
- name — VARCHAR(10)
RequestCafe
- id — INT — Primary key — NOT NULL
- CafeID (id2) — int — Foreign key → Cafe.id — NOT NULL
- Status — INT
- UserID — INT
- Date — DATETIME
User
- id (Key) — Primary key — NOT NULL