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