2시

테이블 (6)

Board

  • ID — INT — 기본 키 — NOT NULL
  • postTitle — VARCHAR(255)
  • creationDate — DATETIME

Comment

  • ID — INT — 기본 키 — NOT NULL
  • content — TEXT
  • creationDate — DATETIME
  • modificationDate — DATETIME
  • postID — INT — 외래 키 → Post.ID — NOT NULL
  • userID — INT — 외래 키 → User.ID — NOT NULL

Post

  • ID — INT — 기본 키 — NOT NULL
  • postTitle — VARCHAR(255)
  • views — INT
  • content — TEXT
  • creationDate — DATETIME
  • modificationDate — DATETIME
  • userID — INT — 외래 키 → User.ID — NOT NULL
  • boardID — INT — 외래 키 → Board.ID — NOT NULL

Profile

  • ID — INT — 기본 키 — NOT NULL
  • userID — INT — 외래 키 → User.ID — NOT NULL
  • imageID — INT — NOT NULL

User

  • ID — INT — 기본 키 — NOT NULL
  • password — VARCHAR(255)
  • email — VARCHAR(255)

Users (spirits)

  • id — int — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — varchar(100)
  • alcohol_degree — decimal(5,2)
  • price — decimal(10,2)
  • description — text
  • image_path — varchar(255)
  • created_at — timestamp
  • name — varchar(255) — NOT NULL
  • base_spirits — json — NOT NULL
  • category — varchar(255)
  • garnish — varchar(255)
  • glass_type — varchar(255)
  • instructions — text
  • description — text
  • alcohol_degree — float
  • image_path — varchar(255)
  • ingredients — json — NOT NULL
  • created_at — timestamp
  • path — VARCHAR(255)
  • originalFileName — VARCHAR(255)
  • creationDate — DATETIME