asd
Tables (10)
article
- id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- regdate — DATETIME — NOT NULL
- views — INT — NOT NULL
- group — VARCHAR(20) — NOT NULL
- cate — VARCHAR(20) — NOT NULL
- user_uid — VARCHAR(50) — Foreign key → user.uid — NOT NULL
article_file
- id — INT — Primary key — NOT NULL
- origin_name — VARCHAR(100) — NOT NULL
- stored_name — VARCHAR(100) — NOT NULL
- regdate — DATETIME
- article_id — INT — Foreign key → article.id — NOT NULL
cart
- id — INT — Primary key — NOT NULL
- count — INT — NOT NULL
- product_id — INT — Foreign key → product.id — NOT NULL
- user_uid — VARCHAR(50) — Foreign key → user.uid — NOT NULL
comment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- article_id — INT — Foreign key → article.id — NOT NULL
- user_uid — VARCHAR(50) — Foreign key → user.uid — NOT NULL
order
- id — INT — Primary key — NOT NULL
- point — INT — NOT NULL
- receiver — VARCHAR(45) — NOT NULL
- receiver_hp — CHAR(13) — NOT NULL
- zip — VARCHAR(20) — NOT NULL
- addr1 — VARCHAR(100) — NOT NULL
- addr2 — VARCHAR(200)
- pay_method — VARCHAR(45) — NOT NULL
- etc — TEXT
- created_at — DATETIME — NOT NULL
- user_uid — VARCHAR(50) — Foreign key → user.uid — NOT NULL
order_item
- id — INT — Primary key — NOT NULL
- price — INT — NOT NULL
- point — INT — NOT NULL
- discount — INT — NOT NULL
- delivery_fee — INT — NOT NULL
- count — INT — NOT NULL
- order_id — INT — Foreign key → order.id — NOT NULL
- product_id — INT — Foreign key → product.id — NOT NULL
point
- id — INT — Primary key — NOT NULL
- points — INT — NOT NULL
- description — VARCHAR(100) — NOT NULL
- pointcol — VARCHAR(45) — NOT NULL
- created_at — DATETIME — NOT NULL
- user_uid — VARCHAR(50) — Foreign key → user.uid — NOT NULL
product
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- price — INT — NOT NULL
- point — INT — NOT NULL
- discount — INT — NOT NULL
- delivery_fee — INT — NOT NULL
- stock — INT — NOT NULL
- img1 — VARCHAR(100)
- img2 — VARCHAR(100)
- img3 — VARCHAR(100)
- regdate — DATETIME — NOT NULL
- etc — TEXT
- user_uid1 — VARCHAR(50) — Foreign key → user.uid — NOT NULL
term
- term_name — VARCHAR(45) — Primary key — NOT NULL
- term_content — TEXT — NOT NULL
user
- uid — VARCHAR(50) — Primary key — NOT NULL
- pass — VARCHAR(50) — NOT NULL
- nick — VARCHAR(45) — NOT NULL
- email — VARCHAR(45) — NOT NULL
- hp — CHAR(13) — NOT NULL
- grade — VARCHAR(20) — NOT NULL
- zip — VARCHAR(20) — NOT NULL
- addr1 — VARCHAR(100) — NOT NULL
- addr2 — VARCHAR(200)
- regip — VARCHAR(40) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME