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