커피주문

테이블 (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