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