test

Tables (37)

Admin

  • id — integer — NOT NULL
  • role — "AdminRole" — NOT NULL
  • loginId — character — NOT NULL
  • password — character — NOT NULL
  • nickname — character — NOT NULL
  • business_name — character
  • state — "AdminState" — NOT NULL
  • profile_image_url — character
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

AdminToken

  • id — integer — NOT NULL
  • access_token — text — NOT NULL
  • is_expiration — boolean — NOT NULL
  • ip — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • admin_id — integer — NOT NULL

AppVersion

  • id — integer — NOT NULL
  • appType — "AppType" — NOT NULL
  • os — "OSType" — NOT NULL
  • version — character — NOT NULL
  • type — integer — NOT NULL
  • created_at — timestamp(3) — NOT NULL

Banner

  • id — integer — NOT NULL
  • type — "BannerType" — NOT NULL
  • position — character — NOT NULL
  • title — character — NOT NULL
  • content — character
  • pc_content_url — character
  • mobile_content_url — character
  • link_url — character
  • state — "BannerState" — NOT NULL
  • postingStartDate — timestamp(3) — NOT NULL
  • postingEndDate — timestamp(3) — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

EBook

  • id — integer — NOT NULL
  • name — character — NOT NULL
  • by — character — NOT NULL
  • thumbnail_url — character — NOT NULL
  • pdf_url — character — NOT NULL
  • state — "EBookState" — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

EBookAuthCode

  • id — integer — NOT NULL
  • auth_code — character — NOT NULL
  • state — "EBookAuthCodeState" — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

EBookAuthCodeToken

  • id — integer — NOT NULL
  • access_token — text — NOT NULL
  • expiration — boolean — NOT NULL
  • ip — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • e_book_auth_code_id — integer — NOT NULL

NotificationHistory

  • id — integer — NOT NULL
  • fcm_id — character
  • state — "NotificationState" — NOT NULL
  • title — character — NOT NULL
  • data_event — character
  • data_action — character
  • data_id — character
  • data_value — character
  • send_at — timestamp(3)
  • created_at — timestamp(3) — NOT NULL
  • user_id — integer
  • data_inner_url — character
  • data_outer_url — character
  • topic — character
  • body — character — NOT NULL

Order

  • id — integer — NOT NULL
  • state — "OrderState" — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • user_id — integer — NOT NULL

OrderDetail

  • id — integer — NOT NULL
  • productName — character
  • productPrice — numeric(12,0)
  • product_discount_amount — numeric(12,0)
  • quantity — integer — NOT NULL
  • coupon_amount — numeric(12,0) — NOT NULL
  • point_amount — numeric(12,0) — NOT NULL
  • order_id — integer — NOT NULL
  • product_id — integer — NOT NULL
  • product_schedule_id — integer — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • userId — integer
  • product_schedule_end_date — timestamp(3)
  • product_schedule_start_date — timestamp(3)
  • state — "OrderDetailState" — NOT NULL
  • amount — numeric(12,0) — NOT NULL

PaymentHistory

  • id — integer — NOT NULL
  • pg_id — character
  • imp_id — character
  • pg_provider — character
  • receipt_url — character
  • pay_method — "PayMethod"
  • state — "PaymentState" — NOT NULL
  • amount — numeric(12,0)
  • refund_amount — numeric(12,0)
  • card_apply_num — character
  • card_number — character
  • card_name — character
  • card_code — character
  • card_type — "CardType"
  • card_quota — integer
  • bank_name — character
  • bank_code — character
  • vbank_num — character
  • vbank_name — character
  • vbank_holder — character
  • vbank_expired_at — timestamp(3)
  • fail_reason — character
  • failed_at — timestamp(3)
  • paid_at — timestamp(3)
  • created_at — timestamp(3) — NOT NULL
  • order_id — integer — NOT NULL
  • userId — integer — NOT NULL
  • adminId — integer

Post

  • id — integer — NOT NULL
  • isTop — boolean — NOT NULL
  • isSecret — boolean — NOT NULL
  • isComment — boolean — NOT NULL
  • viewCount — integer — NOT NULL
  • likeCount — integer — NOT NULL
  • title — character — NOT NULL
  • content — text — NOT NULL
  • images — character
  • state — "PostState" — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)
  • userId — integer
  • adminId — integer
  • postTypeId — integer — NOT NULL
  • postCategoryId — integer
  • productId — integer

PostComment

  • id — integer — NOT NULL
  • content — character — NOT NULL
  • state — "PostCommentState" — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)
  • userId — integer
  • adminId — integer
  • postId — integer — NOT NULL

PostLikeHistory

  • id — integer — NOT NULL
  • post_id — integer — NOT NULL
  • user_id — integer — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

Product

  • id — integer — NOT NULL
  • state — "ProductState" — NOT NULL
  • name — character — NOT NULL
  • topComment — character
  • description — character — NOT NULL
  • thumbnail_url — character
  • representative_image_urls — character
  • content — text — NOT NULL
  • keywords — character
  • viewCount — integer — NOT NULL
  • likeCount — integer — NOT NULL
  • address — character
  • sub_address — character
  • longitude — numeric(15,10)
  • latitude — numeric(15,10)
  • address_title — character
  • main_price — numeric(12,0) — NOT NULL
  • main_discount_price — numeric(12,0)
  • main_discount_rate — integer
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)
  • admin_id — integer — NOT NULL

ProductSchedule

  • id — integer — NOT NULL
  • state — "ProductScheduleState" — NOT NULL
  • price — numeric(12,0) — NOT NULL
  • discount_price — numeric(12,0)
  • discount_rate — integer
  • quantity — integer — NOT NULL
  • start_date — timestamp(3) — NOT NULL
  • end_date — timestamp(3) — NOT NULL
  • product_id — integer — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

Terms

  • id — integer — NOT NULL
  • type — "TermsType" — NOT NULL
  • url — character — NOT NULL
  • version — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

User

  • id — integer — NOT NULL
  • o_auth_id — character
  • loginId — character
  • password — character
  • nickname — character
  • email — character
  • phone_number — character
  • profile_image_url — character
  • type — "UserAuthType" — NOT NULL
  • name — character
  • business_name — character
  • role — "UserRole" — NOT NULL
  • os — "OSType"
  • hardware_version — character
  • software_version — character
  • user_device_token — character
  • is_agreed_terms_of_service — boolean
  • is_alarm_settings — boolean
  • state — "UserState" — NOT NULL
  • ci — character
  • is_authentication — boolean
  • gender — "UserGenderType"
  • residency_id_prefix — character
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)

UserBlocked

  • id — integer — NOT NULL
  • reason — character — NOT NULL
  • expired_at — timestamp(3) — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • updated_at — timestamp(3) — NOT NULL
  • deleted_at — timestamp(3)
  • user_id — integer — NOT NULL

UserToken

  • id — integer — NOT NULL
  • access_token — text — NOT NULL
  • is_expiration — boolean — NOT NULL
  • ip — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • user_id — integer — NOT NULL

_Info:ActivityType

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Info:PostCategory

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • postTypeId — integer — NOT NULL

_Info:PostType

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Info:ProductEducationTarget

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Info:ProductLargeCategory

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Info:ProductRegion

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Info:ProductSmallCategory

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • largeCategoryId — integer

_Info:ProductType

  • id — integer — NOT NULL
  • value — character — NOT NULL
  • created_at — timestamp(3) — NOT NULL

_Join:ProductLikesHistory

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:ProductToEducationTargets

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:ProductToProductLargeCategory

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:ProductToProductRegion

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:ProductToProductSmallCategory

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:ProductToProductType

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:UserToActivityType

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_Join:UserToProductSmallCategory

  • A — integer — NOT NULL
  • B — integer — NOT NULL

_prisma_migrations

  • id — character — NOT NULL
  • checksum — character — NOT NULL
  • finished_at — timestamp
  • migration_name — character — NOT NULL
  • logs — text
  • rolled_back_at — timestamp
  • started_at — timestamp — NOT NULL
  • applied_steps_count — integer — NOT NULL