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