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)