Bletcher-Schema-ERD
bletcher erd prev ver
Tables (14)
Copy Of Untitled (order-case1)
- Key (id) — int(11) — Primary key — NOT NULL
- Field2 (user.id) — int(5) — NOT NULL
- Field (created_at)
- Field (updated_at)
- Field2 (deleted_at)
- Field (option)
- Field2 (quantity)
- Field (post.id)
Untitled (orderitem n)
- Key (id) — Primary key — NOT NULL
- Key (order.id) — int(11) — Foreign key → Untitled.Key — NOT NULL
- Field (post.id) — timestamp
- Field (option) — timestamp — NOT NULL
- Field2 (quantity) — timestamp — NOT NULL
- Field (user.id)
Untitled (category)
- Key (id) — int(11) — Primary key — NOT NULL
- Key (parent_id) — int(11) — Foreign key → Untitled.Key
- Field2 (name) — varchar(20) — NOT NULL
- Field2 (left) — int(11)
- Field2 (right) — int(11)
Untitled (mix)
- id (post.id) — int(11) — Foreign key → posts.id — NOT NULL
- username (origin_user) — int(11) — Foreign key → user.username — NOT NULL
- username (sub_user) — int(11) — Foreign key → user.username — NOT NULL
- Field (due_date) — date — NOT NULL
Untitled (favorite)
- username (user.id) — int(11) — Foreign key → user.username — NOT NULL
- id (post.id) — int(11) — Foreign key → posts.id — NOT NULL
- Field (created_at) — timestamp — NOT NULL
Untitled (address)
- Key (id) — int(11) — Primary key — NOT NULL
- username (user.id) — int(11) — Foreign key → user.username — NOT NULL
- Field (street_name_address) — varchar(50) — NOT NULL
- Field (detail_address) — varchar(20) — NOT NULL
- Field (zip_code) — int(6) — NOT NULL
- Field (buliding_name) — varchar(20) — NOT NULL
Untitled (account)
- Key (id) — int(11) — Primary key — NOT NULL
- username (user.id) — int(11) — Foreign key → user.username — NOT NULL
- Field (account_number) — int (11) — NOT NULL
- Field (bank_name) — varchar(20) — NOT NULL
Untitled (order-case 2)
- Key (id) — int(11) — Primary key — NOT NULL
- Field2 (user.id) — int(5) — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field (updated_at) — timestamp — NOT NULL
- Field2 (deleted_at) — timestamp
Untitled (notice)
- Key (id) — int(11) — Primary key — NOT NULL
- username (user.send_id) — int(11) — Foreign key → user.username — NOT NULL
- username (user.receive_id) — int(11) — Foreign key → user.username — NOT NULL
- id (post.id) — int(11) — Foreign key → posts.id — NOT NULL
- Field (notice_type) — enum — NOT NULL
Untitled (funding)
- username (user.id) — int(11) — Foreign key → user.username — NOT NULL
- id (post.id) — int(11) — Foreign key → posts.id — NOT NULL
- Field (created_at) — timestamp — NOT NULL
Untitled (shopitem)
- id (post.id) — int(11) — Foreign key → posts.id — NOT NULL
- Field2 (poster_sales_amount) — int(11)
- Field (coloring_sales_amount) — int(11)
- Field (goods_sales_amount) — int(11)
images (image)
- name (id) — int(11) — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- type — varchar(30) — NOT NULL
- width — int(11) — NOT NULL
- height — int(11) — NOT NULL
posts (post)
- id — int(11) — Primary key — NOT NULL
- username (user.id) — int(11) — Foreign key → user.username — NOT NULL
- name (image.id) — int(11) — Foreign key → images.name — NOT NULL
- Key (category.id) — int(11) — Foreign key → Untitled.Key
- Field (title) — varchar(50) — NOT NULL
- text (description) — varchar(255)
- Field (is_public) — tinyint — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Field3 (deleted_at) — timestamp
user
- username (id) — int(11) — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- username (email) — varchar(30) — NOT NULL
- Field (user_id) — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL
- Field (phone) — varchar(30) — NOT NULL
- Field (birth) — date — NOT NULL
- Field (introduce) — text
- Field (profile_image) — varchar(30)
- Field (created_at) — timestamp — NOT NULL
- Field2 (updated_at) — timestamp — NOT NULL
- Field3 (deleted_at) — timestamp