test

Tables (26)

address_seq

  • next_val — bigint

business_info

  • business_info_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • business_city — varchar(255)
  • business_street — varchar(255)
  • business_zipcode — varchar(255)
  • business_category — varchar(255)
  • comm_created_at — datetime(6)
  • comm_file_name — varchar(255)
  • comm_file_url — varchar(255)
  • comm_sequence — int
  • comm_updated_at — datetime(6)
  • business_domain — varchar(255)
  • regi_created_at — datetime(6)
  • regi_file_name — varchar(255)
  • regi_file_url — varchar(255)
  • regi_sequence — int
  • regi_updated_at — datetime(6)
  • business_registration_number — varchar(255)
  • company_name — varchar(255)
  • corporation_number — varchar(255)
  • hygiene_grade — varchar(255)
  • mail_order_sales_registration_number — varchar(255)
  • registration_type — varchar(255)
  • representative_name — varchar(255)

category

  • id — bigint — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • category_color — varchar(255)
  • description — varchar(255)
  • name — varchar(255) — NOT NULL
  • sequence — int — NOT NULL
  • shop_id — binary(16)
  • uuid — binary(16)
  • parent_category_id — bigint

category_seq

  • next_val — bigint

closed_days

  • closed_days_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • closed_days — bit — NOT NULL
  • national_holiday — bit — NOT NULL

contract

  • contract_code — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • contract_content — varchar(255)
  • required — bit — NOT NULL
  • title — varchar(255)

contract_for_shop

  • contract_code — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • contract_content — varchar(255)
  • required — bit — NOT NULL
  • title — varchar(255)

feed

  • feed_id — binary(16) — NOT NULL
  • user_id — binary(16)
  • content — varchar(500)
  • created_at — datetime(6)
  • deleted — bit — NOT NULL
  • fix — bit — NOT NULL
  • shop_id — binary(16)
  • title — varchar(30)
  • updated_at — datetime(6)

feed_comment

  • feed_comment_id — binary(16) — NOT NULL
  • user_id — binary(16)
  • content — varchar(100)
  • created_at — datetime(6)
  • deleted — bit
  • updated_at — datetime(6)
  • feed_id — binary(16)
  • parent_feed_comment_id — binary(16)

feed_comment_like

  • feed_comment_like_id — binary(16) — NOT NULL
  • user_id — binary(16)
  • feed_comment_id — binary(16)

feed_feed_images

  • feed_feed_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • file_name — varchar(255)
  • file_url — varchar(255)
  • sequence — int — NOT NULL
  • updated_at — datetime(6)

feed_like

  • feed_like_id — binary(16) — NOT NULL
  • user_id — binary(16)
  • feed_id — binary(16)

inquiry

  • enquiry_id — binary(16) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • answer — varchar(500)
  • answer_status — varchar(255)
  • author_id — binary(16)
  • deleted — bit
  • order_id — binary(16)
  • question — varchar(500)
  • shop_id — binary(16)

inquiry_inquiry_images

  • inquiry_inquiry_id — binary(16) — NOT NULL
  • file_name — varchar(255)
  • file_url — varchar(255)
  • sequence — int — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

item

  • type — varchar(31) — NOT NULL
  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • brand_new — bit — NOT NULL
  • combinable — bit
  • connected_super_store — varchar(255)
  • description — varchar(255)
  • item_code — varchar(255)
  • item_status — varchar(255)
  • name — varchar(255)
  • price — int — NOT NULL
  • recommended — bit — NOT NULL
  • sequences — int
  • uuid — binary(16)
  • version — bigint — NOT NULL
  • item_group_id — bigint

item_group

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • name — varchar(255)
  • sequences — int
  • uuid — binary(16)
  • version — bigint — NOT NULL
  • category_id — bigint

item_item_images

  • item_id — bigint — NOT NULL
  • file_name — varchar(255)
  • file_url — varchar(255)
  • sequence — int — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

item_option_group_relation

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • uuid — binary(16)
  • item_group_id — bigint
  • option_group_id — bigint

item_relation_seq

  • next_val — bigint

my_shop_user

  • user_id — binary(16) — NOT NULL
  • email — varchar(255)
  • nickname — varchar(255) — NOT NULL
  • persona_id — bigint
  • phone_number — varchar(255)

my_shop_user_contract_relation

  • my_shop_user_contract_relation_id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • accepted — bit — NOT NULL
  • contract_id — varchar(255)
  • my_shop_user_id — binary(16)

onsite_item

  • id — bigint — NOT NULL

option

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • item_code — varchar(255)
  • item_status — varchar(255)
  • name — varchar(255)
  • price — int — NOT NULL
  • sequence — int — NOT NULL
  • type — smallint
  • uuid — binary(16)
  • version — bigint — NOT NULL
  • option_group_id — bigint

option_group

  • id — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • max — int — NOT NULL
  • min — int — NOT NULL
  • name — varchar(255)
  • required — bit
  • shop_id — binary(16)
  • uuid — binary(16)
  • version — bigint — NOT NULL

order_line_item_seq

  • next_val — bigint

order_option_group_seq

  • next_val — bigint