커피주문
테이블 (9)
Answer (Untitled8)
- AnswerID (Key) — BIGINT — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- PK (memberId) — BIGINT — 외래 키 → Memeber.PK — NOT NULL
- QuestionID (PK) — BIGINT — 외래 키 → Question.QuestionID — NOT NULL
- PK (memberId2) — BIGINT — 외래 키 → Question.PK — NOT NULL
- Content (Field) — TEXT
- PostDate (Field2) — DATETIME
- Field3
Coffee (Untitled)
- PK (coffeeId) — BIGINT — 기본 키 — NOT NULL
- korName (Field) — VARCHAR
- engName (Field2) — VARCHAR
- price (Field3) — Integer
- coffeeCode (Field4) — VARCHAR
- coffeeStatus (Field5) — VARCHAR
- createdAt (Field6) — DATETIME
- modifiedAt (Field7) — DATETIME
- Field8
Like (Untitled6)
- LikeID (PK) — BIGINT — 기본 키 — NOT NULL
- QuestionID (PK2) — BIGINT — 외래 키 → Question.QuestionID — NOT NULL
- PK (memberId) — BIGINT — 외래 키 → Question.PK — NOT NULL
- PK (memberId2) — BIGINT — 외래 키 → Memeber.PK — NOT NULL
- LikeDate (Field) — DATETIME
- Field2
Memeber (Untitled3)
- PK (memberId) — BIGINT — 기본 키 — NOT NULL
- email (Field) — VARCHAR
- password (Field7) — String
- name (Field2) — VARCHAR
- phone (Field3) — VARCHAR
- memberStatus (Field4) — VARCHAR
- createdAt (Field5) — DATETIME
- modifiedAt (Field6) — DATETIME
Order (Untitled2)
- Key — BIGINT — 기본 키 — NOT NULL
- PK (memberId) — BIGINT — 외래 키 → Memeber.PK — NOT NULL
- orderStatus (Field) — VARCHAR
- createdAt (Field2) — DATETIME
- modifiedAt (Field3) — DATETIME
- Field4
OrderCoffee (Untitled5)
- ordercoffee (PK) — 기본 키 — NOT NULL
- PK (coffeeId) — BIGINT — 외래 키 → Coffee.PK — NOT NULL
- Key — BIGINT — 외래 키 → Order.Key — NOT NULL
- PK (memberId) — INT — 외래 키 → Order.PK — NOT NULL
- Field (quantity)
Question (Untitled9)
- QuestionID (PK) — BIGINT — 기본 키 — NOT NULL
- PK (memberId) — BIGINT — 외래 키 → Memeber.PK — NOT NULL
- Title (Field) — VARCHAR
- Content (Field2) — TEXT
- PostDate (Field3) — DATETIME
- Status (Field4) — VARCHAR
- Visibility (Field5) — VARCHAR
- Field6
Role (Untitled4)
- Key — BIGINT — 기본 키 — NOT NULL
- PK (memberId) — INT — 외래 키 → Memeber.PK — NOT NULL
- rolename (Field) — VARCHAR
- member (Field2) — VARCHAR
- Field3
View (Untitled7)
- ViewID (PK) — BIGINT — 기본 키 — NOT NULL
- QuestionID (PK2) — BIGINT — 외래 키 → Question.QuestionID — NOT NULL
- PK (memberId) — BIGINT — 외래 키 → Question.PK — NOT NULL
- PK (memberId2) — BIGINT — 외래 키 → Memeber.PK — NOT NULL
- ViewDate (Field) — DATETIME
- Field2