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