Project
Tables (5)
Board (CopyOfUntitled3)
- board_idx (Key3) — int — Primary key — NOT NULL
- user_id (Key) — string — Foreign key → user.user_id — NOT NULL
- password (Field2) — string
- title (Field3) — text
- content (Field4) — text
- image (Field5) — img
- date (Field7) — date
- category (Key2) — string — NOT NULL
Board_ Comment (CopyOfUntitled2)
- idx (Key2) — int — Primary key — NOT NULL
- user_id (Key) — string — Foreign key → user.user_id — NOT NULL
- category (Key3) — string — Foreign key → Board.board_idx — NOT NULL
- content (Field3) — text
- like (Field4) — int
- date (Field5) — date
Upload_File (CopyOfCopyOfUntitled22)
- idx (Key) — int — Primary key — NOT NULL
- board_idx (Key3) — int — Foreign key → Board.board_idx — NOT NULL
- ofile (Field4) — file
- sfile (Field5) — file
- category (Field) — string
user (Untitled)
- user_id (Key) — string — Primary key — NOT NULL
- idx (Field6) — int
- password (Field) — string
- name (Field2) — string
- postCode (Field3) — string
- addr1 (Field10) — String
- addr2 (Field11) — String
- gender (Field4) — char
- birth (Field7) — date
- phone (Field8) — string
- email (Field9) — string
- visitor (Field5) — int
- use (Field12) — int
- lev (Field13) — int
- introduce (Field14) — text
user_comment (Untitled2)
- idx (Key2) — int — Primary key — NOT NULL
- custom_id (Field) — string
- content (Field2) — text
- date (Field3) — date
- user_id (Key) — string — Foreign key → user.user_id — NOT NULL