JukeMap DB Modeling

Tables (5)

BOOKMARK

  • bseq (Key) — INT — Primary key — NOT NULL
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • jseq (Key3) — INT — Foreign key → JUKE.jseq — NOT NULL

JUKE

  • jseq (Key) — INT — Primary key — NOT NULL
  • lat (Field) — DOUBLE
  • lon (Field2) — DOUBLE
  • title (Field3) — VARCHAR
  • content (Field4) — VARCHAR
  • likey (Field5) — INT
  • regdate (Field6) — TIMESTAMP
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL

LIKEY

  • lseq (Key) — INT — Primary key — NOT NULL
  • id (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • jseq (Key3) — INT — Foreign key → JUKE.jseq — NOT NULL

MESSAGE

  • mseq (Key) — INT — Primary key — NOT NULL
  • toid (Key2) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • fromid (Key3) — VARCHAR — Foreign key → USERS.id — NOT NULL
  • msg (Field) — VARCHAR

USERS

  • id (Key) — VARCHAR — Primary key — NOT NULL
  • password (Field) — VARCHAR
  • name (Field2) — VARCHAR