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)