Look

Tables (7)

Comment (Untitled3)

  • cno (Key) — bigint — Primary key — NOT NULL — auto_increment
  • writer (Field) — varchar(200)
  • content (Field2) — text
  • reg_at (Field3) — datetime
  • mod_at (Field4) — datetime
  • Lbno (Key2) — bigint — Foreign key → LBoard.Lbno — NOT NULL

File (Untitled2)

  • uuid (Key) — Primary key — NOT NULL
  • save_dir (Field) — varchar(256)
  • file_name (Field2) — varchar(256)
  • file_type (Field3) — tinyint(1)
  • file_size (Field4) — bigint
  • reg_at (Field5) — datetime
  • Lbno (Key2) — bigint — Foreign key → LBoard.Lbno — NOT NULL

LBoard (Untitled)

  • Lbno (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(200)
  • writer (Field2) — varchar(200)
  • content (Field3) — text
  • reg_at (Field4) — datetime
  • mod_at (Field5) — datetime
  • read_count (Field6) — int
  • like (Field7)

NBoard (Untitled4)

  • Nbno (Key) — bigint — Primary key — NOT NULL — auto_increment
  • title (Field) — varchar(200)
  • writer (Field2) — varchar(200)
  • content (Field3) — text
  • reg_at (Field4) — datetime
  • read_count (Field5) — int

QBoard (Untitled5)

  • Qbno (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar
  • writer (Field2) — varchar(100)
  • content (Field3) — text
  • reg_at (Field4) — datetime

User (Untitled6)

  • email (Key) — varchar(100) — Primary key — NOT NULL
  • pw (Field) — varchar(100)
  • nick_name (Field2)
  • reg_at (Field3) — datetime
  • last_login (Field4) — datetime
  • Field5

auth_user (Untitled7)

  • auth (Field) — varchar(50)
  • email (Key) — varchar(100) — Foreign key → User.email — NOT NULL