jsp_cch
Tables (5)
Untitled (t_inquery_board)
- Key (inquery_board_id) — NUMBER — Primary key — NOT NULL
- Field (title) — NVARCHAR2(100)
- Field2 (content) — NVARCHAR2(2000)
- Field (is_reply) — CHAR(1)
- Field (updated_at) — DATE
- Field3 (created_at) — DATE
- Field4 (deleted_at) — DATE
- Field (is_delete) — CHAR(1)
- Key (user_id) — Number — Foreign key → t_user.Key — NOT NULL
- Key (r_inquery_board_parent_id) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (t_inquery_board_image)
- Key (inquery_board_image_id) — NUMBER — Primary key — NOT NULL
- Field (uri) — NVARCHAR2(1000)
- Field2 (created_at) — DATE
- Field (is_delete) — CHAR(1)
- Key (inquery_board_id) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (t_menu)
- Key (menu_id) — NUMBER — Primary key — NOT NULL
- Field (name) — NVARCHAR2(100)
- Field2 (price) — NVARCHAR2(100)
- Field3 (desc) — NVARCHAR2(500)
- Field (ordering) — NUMBER
- Field (created_at) — DATE
- Field5 (updated_at) — DATE
- Key (menu_category_id) — NUMBER — Foreign key → Untitled.Key
Untitled (t_menu_category)
- Key (menu_category_id) — NUMBER — Primary key — NOT NULL
- Field (name) — NVARCHAR(100)
- Field (ordering) — NUMBER
t_user
- Key (user_id) — Number — Primary key — NOT NULL
- Field (username) — CHAR(30)
- Field2 (password) — NCHAR2(100)
- Field3 (user_nickname) — NCHAR(30)
- Field (grade) — CHAR(10)
- Field4 (created_at) — DATE
- Field (deleted_at) — DATE
- Field2 (is_delete) — CHAR(1)