쇼핑몰2차

테이블 (19)

account

  • id — INT — 기본 키 — NOT NULL
  • payPrice — INT — NOT NULL
  • num — VARCHAR(20) — NOT NULL
  • orders_id — INT — 외래 키 → orders.id — NOT NULL
  • INDEX — `fk_account_orders1_idx`

admin

  • id — INT — 기본 키 — NOT NULL
  • login — VARCHAR(100) — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • part — VARCHAR(25) — NOT NULL
  • joinDay — DATETIME
  • modiDate — DATETIME

brand

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(25) — NOT NULL

card

  • id — INT — 기본 키 — NOT NULL
  • company — VARCHAR(100)
  • name — VARCHAR(100)
  • users_id — INT — 외래 키 → users.id — NOT NULL
  • INDEX — `fk_card_users1_idx`

cart

  • id — INT — 기본 키 — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • users_id — INT — 외래 키 → users.id — NOT NULL
  • INDEX — `fk_cart_goods1_idx`
  • INDEX — `fk_cart_users1_idx`

commcode

  • code — VARCHAR(50) — 기본 키 — NOT NULL
  • topCode — VARCHAR(50)
  • name — VARCHAR(25)
  • explanation — VARCHAR(255)

comment

  • id — INT — 기본 키 — NOT NULL
  • contents — VARCHAR(500) — NOT NULL
  • produceDay — DATETIME — NOT NULL
  • modiDate — DATETIME
  • comment_id — INT — 외래 키 → comment.id — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • INDEX — `fk_comment_comment1_idx`
  • INDEX — `fk_comment_goods1_idx`

company

  • id — INT — 기본 키 — NOT NULL
  • login — VARCHAR(100) — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • compName — VARCHAR(100) — NOT NULL
  • number — VARCHAR(11) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • joinDay — DATETIME — NOT NULL
  • modiDate — DATETIME

goods

  • id — INT — 기본 키 — NOT NULL
  • brand_id — INT — 외래 키 → brand.id — NOT NULL
  • goods_type — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • colorType — VARCHAR(25) — NOT NULL
  • discount_price — INT

goodspost

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(500) — NOT NULL
  • tag — VARCHAR(25)
  • produceDay — DATETIME — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • company_id — INT — 외래 키 → company.id — NOT NULL
  • INDEX — `fk_goodspost_goods1_idx`
  • INDEX — `fk_goodspost_company1_idx`

img

  • id — INT — 기본 키 — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • path — VARCHAR(100) — NOT NULL
  • type — VARCHAR(100) — NOT NULL
  • createDay — DATETIME

inven

  • id — INT — 기본 키 — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • options_id — INT — 외래 키 → options.id — NOT NULL
  • storeDay — DATETIME — NOT NULL
  • modiDate — DATETIME
  • count — INT — NOT NULL
  • lastUpdate — DATETIME — NOT NULL
  • INDEX — `fk_inven_goods1_idx`
  • INDEX — `fk_inven_options1_idx`

like

  • id — INT — 기본 키 — NOT NULL
  • favDate — DATETIME — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • INDEX — `fk_like_goods1_idx`

notice

  • id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • createDay — DATETIME
  • img — VARCHAR(45)

options

  • id — INT — 기본 키 — NOT NULL
  • goods_id — INT — 외래 키 → goods.id — NOT NULL
  • color — VARCHAR(25) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • discount_price — INT

orders

  • id — INT — 기본 키 — NOT NULL
  • addr — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • goodsPrice — INT — NOT NULL
  • payPrice — INT — NOT NULL
  • discountPrice — INT
  • request — VARCHAR(255)
  • orderDay — DATETIME — NOT NULL
  • card_id — INT — 외래 키 → card.id — NOT NULL
  • cart_id — INT — 외래 키 → cart.id — NOT NULL
  • INDEX — `fk_orders_card1_idx`
  • INDEX — `fk_orders_cart1_idx`

question

  • id — INT — 기본 키 — NOT NULL
  • contents — VARCHAR(500) — NOT NULL
  • produceDay — DATETIME — NOT NULL
  • delDate — DATETIME
  • modiDate — DATETIME
  • users_id — INT — 외래 키 → users.id — NOT NULL
  • INDEX — `fk_question_users1_idx`

recomment

  • id — INT — 기본 키 — NOT NULL
  • contents — VARCHAR(255) — NOT NULL
  • createDay — DATETIME — NOT NULL
  • question_id — INT — 외래 키 → question.id — NOT NULL
  • INDEX — `fk_recomment_question1_idx`

users

  • id — INT — 기본 키 — NOT NULL
  • login — VARCHAR(100) — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nick — VARCHAR(100) — NOT NULL
  • grade — VARCHAR(50)
  • number — VARCHAR(15) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • joinDay — DATETIME
  • modiDate — DATETIME