MODOO DB Modeling

Tables (13)

BOARD

  • bseq (Key) — INT — Primary key — NOT NULL
  • bnum (Field) — INT
  • btype (Field2) — VARCHAR
  • title (Field3) — VARCHAR
  • content (Field4) — VARCHAR
  • regdate (Field5) — TIMESTAMP
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

CHAT

  • cseq (Key) — INT — Primary key — NOT NULL
  • data (Field) — VARCHAR
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • rnum (Key3) — INT — Foreign key → ROOM.rnum — NOT NULL

COMMENT

  • cseq (Key) — INT — Primary key — NOT NULL
  • content (Field) — VARCHAR
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • bseq (Key3) — INT — Foreign key → BOARD.bseq — NOT NULL

DATA

  • dseq (Key) — INT — Primary key — NOT NULL
  • data (Field) — VARCHAR
  • inum (Key2) — INT — Foreign key → INFO.seq — NOT NULL

FRAME

  • fseq (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • regdate (Field3) — TIMESTAMP
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

FRAME_HAVE_INFO

  • fhiseq (Key) — INT — Primary key — NOT NULL
  • fseq (Key2) — INT — Foreign key → FRAME.fseq — NOT NULL
  • inum (Key3) — INT — Foreign key → INFO.seq — NOT NULL

INFO

  • seq (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • link (Field2) — VARCHAR
  • content (Field3) — VARCHAR
  • field (Field4) — VARCHAR
  • cssquery (Field5) — VARCHAR
  • regdate (Field6) — TIMESTAMP
  • itype (Field7) — VARCHAR
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

ROOM

  • rnum (Key) — INT — Primary key — NOT NULL
  • rtitle (Field) — VARCHAR
  • regdate (Field2) — TIMESTAMP
  • id (Key3) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • bseq (Key2) — INT — Foreign key → BOARD.bseq — NOT NULL

TM

  • tseq (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • ttype (Field3) — VARCHAR
  • regdate (Field4) — TIMESTAMP
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

TM_HAVE_INFO

  • thiseq (Key) — INT — Primary key — NOT NULL
  • tseq (Key2) — INT — Foreign key → TM.tseq — NOT NULL
  • seq (Key3) — INT — Foreign key → INFO.seq — NOT NULL

USERS

  • id (Key) — VARCHAR — Primary key — NOT NULL
  • password (Field) — VARCHAR
  • name (Field2) — VARCHAR
  • phone (Field3) — VARCHAR
  • email (Field4) — VARCHAR
  • company (Field5) — VARCHAR

VISUAL

  • vseq (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • vtype (Field3) — VARCHAR
  • regdate (Field4) — TIMESTAMP
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

VISUAL_HAVE_INFO

  • vhiseq (Key) — INT — Primary key — NOT NULL
  • dtype (Field) — VARCHAR
  • vseq (Key2) — INT — Foreign key → VISUAL.vseq — NOT NULL
  • seq (Key3) — INT — Foreign key → INFO.seq — NOT NULL