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