Soolae

Tables (8)

banner

  • id — BIGINT(19) — Primary key — NOT NULL
  • file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • src — TEXT
  • order — INT(10) — NOT NULL

cocktail

  • id — BIGINT(19) — Primary key — NOT NULL — 아이디
  • file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
  • user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
  • cocktail_name — VARCHAR(50) — NOT NULL — 이름' COLLATE 'utf8mb4_general_ci
  • proof — FLOAT — NOT NULL — 도수
  • glass — VARCHAR(50) — NOT NULL — 잔' COLLATE 'utf8mb4_general_ci
  • method — VARCHAR(50) — NOT NULL — 기법' COLLATE 'utf8mb4_general_ci
  • garnish — VARCHAR(50) — 가니시' COLLATE 'utf8mb4_general_ci
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL

cocktail_ingredient

  • id — BIGINT(19) — Primary key — NOT NULL
  • cocktail_id — BIGINT(19) — Foreign key → cocktail.id — NOT NULL — 아이디
  • ingredient_id — BIGINT(19) — Foreign key → ingredient.id — NOT NULL
  • volume — DOUBLE — NOT NULL
  • unit — VARCHAR(100) — NOT NULL

comment

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
  • target_user — BIGINT(19)
  • content — VARCHAR(500)
  • ref_category — VARCHAR(200)
  • created_at — DATETIME
  • deleted — BOOLEAN
  • comment_group — NUMBER

files

  • id — BIGINT(19) — Primary key — NOT NULL
  • 업로더 (uploader) — BIGINT(19) — Foreign key → user.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(2048) — NOT NULL
  • file_size — BIGINT(19)
  • file_type — VARCHAR(200)
  • created_at — DATETIME — NOT NULL

ingredient

  • id — BIGINT(19) — Primary key — NOT NULL
  • file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • en_name — VARCHAR(100)
  • category — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • INDEX — `FK_ingredient_files`

oauth_user (간편로그인 유저)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
  • email — VARCHAR(200)
  • domain — VARCHAR(100)

user

  • id — BIGINT(19) — Primary key — NOT NULL
  • nick_name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255)
  • email — VARCHAR(100) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • login_method — VARCHAR(50)