Bletcher

bletcher erd prev ver

Tables (12)

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)

  • Key (id) — int(11) — Primary key — NOT NULL
  • 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
  • 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)

  • Key (id) — int(11) — Primary key — NOT NULL
  • Field2 (quantity) — int(5) — NOT NULL
  • Field (option) — varchar(20) — NOT NULL
  • username (user_id) — int(11) — Foreign key → user.username — NOT NULL
  • id (post_id) — int(11) — Foreign key → Untitled.id — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp — NOT NULL
  • Field3 (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 (path) — varchar(50) — 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 — NOT NULL
  • Field (title) — varchar(50) — NOT NULL
  • text (description) — varchar(255) — NOT NULL
  • 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
  • username (email) — varchar(30) — NOT NULL
  • Field (nickname) — varchar(20) — NOT NULL
  • password — varchar(20) — NOT NULL
  • Field (introduce) — text
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp — NOT NULL
  • Field3 (deleted_at) — timestamp