ourmenu2
Tables (7)
Menu
- menu_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- store_id — BIGINT — Foreign key → Place.place_id — NOT NULL
- menuFolder_id — BIGINT — Foreign key → MenuFolder.menuFolder_id — NOT NULL
- title — VARCHAR — NOT NULL
- price — BIGINT — NOT NULL
- created_at — timestamp — NOT NULL
- modified_at — timestamp — NOT NULL
- status — VARCHAR — NOT NULL
- memo — VARCHAR
- icon — VARCHAR
- Field — VARCHAR(255)
MenuFolder
- menuFolder_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- title — VARCHAR — NOT NULL
- created_at — timestamp — NOT NULL
- modified_at — timestamp — NOT NULL
- status — VARCHAR — NOT NULL
- img_url — VARCHAR
- icon_type (icon_typr) — VARCHAR — NOT NULL
- priority — BIGINT — NOT NULL
MenuImage
- menu_image_id — BIGINT — Primary key — NOT NULL
- menu_id — BIGINT — Foreign key → Menu.menu_id — NOT NULL
- img_url — VARCHAR — NOT NULL
Menu_Tag
- menu_tag_id — BIGINT — Primary key — NOT NULL
- menu_id — BIGINT — Foreign key → Menu.menu_id — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.tag_id — NOT NULL
Place
- place_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- latitude — decimal(20, 17) — NOT NULL
- longitude — decimal(20, 17) — NOT NULL
- title — VARCHAR — NOT NULL
- created_at — timestamp — NOT NULL
- modified_at — timestamp — NOT NULL
- status — VARCHAR — NOT NULL
- address — VARCHAR — NOT NULL
- memo — VARCHAR
Tag
- tag_id — BIGINT — Primary key — NOT NULL
- tag_name — VARCHAR — NOT NULL
- isCustom — VARCHAR — NOT NULL
User
- user_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- created_at — timestamp — NOT NULL
- modified_at — timestamp — NOT NULL
- email — VARCHAR — NOT NULL
- status — VARCHAR — NOT NULL
- img_url — VARCHAR