쇼핑몰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