dumdumgen

Tables (9)

Copy Of Untitled (option)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Key (field_id) — int — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (table_filed_option)

  • Key (id) — int — Primary key — NOT NULL
  • Field (detail) — json
  • Field (reg_dt) — datetime — NOT NULL
  • Field2 (mod_dt) — datetime — NOT NULL
  • Field (option_id) — int — NOT NULL
  • Key (table_field_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (user)

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar(100) — NOT NULL
  • Field2 (email) — varchar(100) — NOT NULL
  • Field (login_type) — varchar(10) — NOT NULL
  • Field3 (active_yn) — enum('Y','N') — NOT NULL
  • Field4 (reg_dt) — datetime — NOT NULL
  • Field5 (mod_dt) — datetime — NOT NULL

Untitled (project)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field2 (desc) — varchar(1000)
  • Field (delete_yn) — enum('Y','N')
  • Field (delete_dt) — datetime
  • Field (mod_dt) — datetime — NOT NULL
  • Field (reg_dt) — datetime — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key

Untitled (table)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — varchar(30) — NOT NULL
  • Field2 (desc) — varchar(100)
  • Field3 (project_sort) — int — NOT NULL
  • Field (reg_dt) — datetime — NOT NULL
  • Field (mod_dt) — datetime — NOT NULL
  • Key (project_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (table_field)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field2 (sort) — int — NOT NULL
  • Field (reg_dt) — datetime — NOT NULL
  • Field2 (mod_dt) — datetime — NOT NULL
  • Field (field_id) — int
  • Key (table_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (field)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL

Untitled (category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL

Untitled (field_category)

  • Key (id) — int — Primary key — NOT NULL
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (field_id) — int — Foreign key → Untitled.Key — NOT NULL