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