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