play

Tables (16)

Address (member_address)

  • Member Identity (id) — varchar(100) — Foreign key → Member.Member Identity — NOT NULL
  • Address (city) (city) — varchar(100)
  • Address (street) (street) — varchar(100)
  • Address (zipcode) (zipcode) — varchar(100)

Book (book)

  • Product Identity (id) — varchar(100) — Primary key — NOT NULL
  • Product Name (name) — varchar(255)
  • Product Maker (maker) — varchar(255)
  • Product Price (price) — int(11)
  • Author (author) — varchar(100)
  • Type (type) — varchar(100)
  • ISBN (isbn) — varcahr(255)

Club (club)

  • Club Identity (id) — bigint — Primary key — NOT NULL
  • Club Name (name) — varchar(255)
  • Club Ranking (ranking) — int(11)

Delivery (basquiat_delivery)

  • Delivery Identity (id) — bigint — Primary key — NOT NULL
  • Delivery Courier (courier) — varchar(50)
  • Delivery Status (status) — varchar(20)
  • Delivery Place (place) — varchar(255)
  • Delivery Date (delivery_at) — datetime
  • Deliver Completed Date (completed_at) — datetime

Instrumental (instrumental)

  • Product Identity (id) — varchar(100) — Primary key — NOT NULL
  • Product Name (name) — varchar(255)
  • Product Maker (maker) — varchar(255)
  • Product Price (price) — int(11)
  • String Count (string_cnt) — int(1)
  • Body Wood (body_wood) — varchar(100)
  • Neck Wood (neck_wood) — varchar(100)
  • Finger Wood (finger_wood) — varchar(100)
  • Type (type) — varchar(100)

InstrumentalString (instrumental_string)

  • Product Identity (id) — varchar(100) — Primary key — NOT NULL
  • Product Name (name) — varchar(255)
  • Product Maker (maker) — varchar(255)
  • Product Price (price) — int(11)
  • Material (material) — varchar(50)
  • Is Coating (is_coating) — varchar(1)
  • Count (count) — int(1)

Item (basquiat_item_master)

  • Item Id (id) — varchar(30) — Primary key — NOT NULL
  • Item Name (it_name) — varchar(255)
  • Item Model (it_model) — varchar(255)
  • Regist Date (created_at) — datetime
  • Modify Date (updated_at) — datetime

Item (item)

  • Item Identity Id (id) — varchar(50) — Primary key — NOT NULL
  • Item Name (it_name) — varchar(255)
  • Item Model (it_model) — varchar(255)
  • Item Maker (maker) — varchar(50)

Item Delivery Policy (item_delivery_policy)

  • Identity (id) — bigint — Primary key — NOT NULL
  • Item Identity Id (id2) — varchar(50) — Foreign key → Item.Item Identity Id — NOT NULL
  • Delivery Is (is_delivery) — varchar(1)
  • Delivery Fee (delivery_fee) — int(11)
  • Delivery Add Fee (delivery_add_fee) — int(11)
  • 그외 (...) — ...

Item Image (item_image)

  • Identity (id) — biging — Primary key — NOT NULL
  • Item Identity Id (id2) — varchar(50) — Foreign key → Item.Item Identity Id — NOT NULL
  • Item Thumbnail (it_thumb) — varchar(255)
  • Item Image1 (it_img1) — varchar(255)
  • 그외 (...) — ...

Locker (locker)

  • Locker Identity (id) — bigint — Primary key — NOT NULL
  • Locker Name (name) — varchar(255)
  • Locker Position (position) — varchar(255)

Member (basquiat_member)

  • Member Unique Identity (id) — bigint — Primary key — NOT NULL
  • Member Name (mb_name) — varchar(100)
  • Member Email (mb_email) — varchar(100)
  • Member Phone (mb_phone) — varchar(20)
  • Membmer Address (mb_address) — varchar(255)
  • Member Regist Date (signup_at) — datetime

Member (member)

  • Member Identity (id) — varchar(100) — Primary key — NOT NULL
  • Member Name (name) — varchar(100)
  • Member Birth (birth) — varchar(10)
  • Address (city) (city) — varchar(100)
  • Address (street) (street) — varchar(100)
  • Address (zipcode) (zipcode) — varchar(100)

Order (basquiat_order)

  • Order Identity (id) — bigint — Primary key — NOT NULL
  • Member Unique Identity (member_id) — bigint — Foreign key → Member.Member Unique Identity — NOT NULL
  • Delivery Identity (delivery_id) — bigint — Foreign key → Delivery.Delivery Identity — NOT NULL
  • Order Status (status) — varchar(20)
  • Order Date (order_at) — datetime

OrderDetail (basquiat_order_detail)

  • Order Detail Identity (id) — bigint — Primary key — NOT NULL
  • Order Identity (order_id) — bigint — Foreign key → Order.Order Identity — NOT NULL
  • Item Id (item_id) — varchar(30) — Foreign key → Item.Item Id — NOT NULL
  • Order Item Quantity (quantity) — int(11)
  • Order Item Total Price (price) — int(11)
  • Order Item Option Id (io_id) — int(11)
  • Order Item Option Name (io_name) — varchar(100)

Player (player)

  • Player Identity (id) — bigint — Primary key — NOT NULL
  • Club Identity (club_id) — bigint — Foreign key → Club.Club Identity — NOT NULL
  • Locker Identity (locker_id) — bigint — Foreign key → Locker.Locker Identity — NOT NULL
  • Player Name (name) — varchar(255)
  • Player Age (age) — int(11)
  • Position (position) — varchar(50)