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