Fooding

Tables (7)

Bank (Untitled7)

  • AccountID (accountid) — int — Primary key — NOT NULL
  • User.id (owner) — varchar — Foreign key → User.ID — NOT NULL
  • BankName (back) — varchar
  • BankAccountNumber (banknum) — varchar

Board (Untitled)

  • Number (num) — int — Primary key — NOT NULL
  • User.id (writerid) — varchar — Foreign key → User.ID — NOT NULL
  • Title (title) — varchar
  • Country (country) — varchar
  • FoodType (foodtype) — varchar
  • Ingredients (ingredients) — varchar
  • Tool used (tools) — varchar
  • registeredDate (reg_date) — varchar
  • ReadCount (readcount) — int
  • Content (content) — varchar
  • Thumbnail (thumbnail) — varchar

Buy (Untitled5)

  • BuyID (buyid) — int — Primary key — NOT NULL
  • User.id (owner) — varchar — Foreign key → User.ID — NOT NULL
  • Product.productid (productid) — int — Foreign key → Product.ProductID — NOT NULL
  • Bank.accountid (accountid) — int — Foreign key → Bank.AccountID — NOT NULL
  • boughtDate (buydate) — DateTime
  • Address (deliveryAddress) — varchar

Comment (Untitled4)

  • Number (num) — int — Primary key — NOT NULL
  • Board.num (rootin) — int — Foreign key → Board.Number — NOT NULL
  • User.id (owner) — varchar — Foreign key → User.ID — NOT NULL
  • Content (content) — varchar
  • registedDate (reg_date) — DateTime
  • reference (ref) — int
  • reply step (re_step) — int
  • reply level (re_levelN) — int

Point (Untitled3)

  • Number (num) — int — Primary key — NOT NULL
  • User.id (owner) — varchar — Foreign key → User.ID — NOT NULL
  • Adjestment (pointadjest) — int
  • Reason (adjestreason) — varchar
  • registedDate (reg_date) — DateTime

Product (Untitled6)

  • ProductID (productid) — int — Primary key — NOT NULL
  • ProductName (productname) — varchar
  • price — int
  • productThumbnail (productThumb) — varchar

User (Untitled2)

  • ID (id) — varchar — Primary key — NOT NULL
  • Nickname (nkname) — varchar
  • Password (passwd) — varchar
  • Email (email) — varchar
  • Mileage (mileage) — int
  • isAdmin — int
  • isLeft — int