Nothing
Code
dm
Output
-- Metadata --------------------------------------------------------------------
Tables: `x`, `y`
Columns: 5
Primary keys: 2
Foreign keys: 1
Code
df$sql_table
Output
<SQL> CREATE TEMPORARY TABLE `x` (
`x_id` INTEGER,
`x_data` TEXT,
PRIMARY KEY (`x_id`)
)
<SQL> CREATE TEMPORARY TABLE `y` (
`y_id` INTEGER,
`x_id` INTEGER,
`y_data` TEXT,
PRIMARY KEY (`y_id`),
FOREIGN KEY (`x_id`) REFERENCES `x` (`x_id`)
)
Code
dm_paste(dm)
Message
dm::dm(
x,
y,
) %>%
dm::dm_add_pk(x, x_id, autoincrement = TRUE) %>%
dm::dm_add_pk(y, y_id) %>%
dm::dm_add_fk(y, x_id, x)
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.